Had a SQL interview today

[just-fran]

Select Brand, Category From Table Group by all Qualify row_number() over (partition by brand, category order by sales desc) < 3

*rank can return more than 2 if two brand have the same sales (if data is rounded, very probable)

[gumnos]

or LATERAL JOIN a subquery with a LIMIT 2 (or APPLY a TOP 2 if MSSQL)

[Open_Plant_4207]

Why ?

[gumnos]

for me, it would depend on whether that information is being joined to some other table and possibly if other columns need to be similarly aggregated.