How To Group By with Multiple Columns in SQL

[@walkingradiance9556]

What are the more complex operations with group by where the order does matter? having? window functions like dense rank?

[@DatabaseStar]

Yeah, window functions like DENSE_RANK, LEAD, and LAG. And I think the order of data will make more sense with complex grouping such as GROUPING SETS.

[@arbazadam3407]

I find group by annoying and weirdly complicated :P

[@DatabaseStar]

Thanks for sharing, yeah it can be a little complicated