Why MAX with GROUP BY returns lots of rows?


#1

SELECT name, category, MAX(downloads) FROM fake_apps GROUP BY category;

Why and how does this query give so many rows? I thought it will give only one row with the highest downloads. :confused:


#2

you are grouping by category and then each group you are finding a max.


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.