Use SQL query with window functions like ROW_NUMBER() to select consecutive data from a column

• Use ROW_NUMBER() to assign a unique number to each row based on a specific order

• Use a self join or subquer...read more