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.
you are grouping by category and then each group you are finding a max.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.