Re: extract the first 10 catalogs have sold the most...

[Peter Brawley]

Read about Group By in the manual.

Is this what you mean?

SELECT catalog, SUM(X) AS Tot
FROM table
GROUP BY Catalog -- correction
ORDER BY Tot DESC
LIMIT 10;



Edited 1 time(s). Last edit at 12/22/2021 11:50PM by Peter Brawley.