February 2020
Intermediate to advanced
467 pages
8h 30m
English
Grouping data with a group by clause requires you to find one or more values that are the same in those rows you want to belong to the same group. Often that is simply some columns or just as often a calculation on some columns.
Sometimes, though, the condition that tells you a row belongs to a group is not simply a condition you can calculate using only values from that row itself, but the condition is on how the row relates to other rows. A condition to group by could, for example, be that all rows with consecutive sequential values should be grouped – when a gap in the ...