It can be very useful to be able to generate row numbers for each group, which lets you do things like return the first 1 or X rows per group, but the ROW_NUMBER() function in AlaSQL appears to return the row numbers not of the group but of the result set overall.