Code: Select all
SELECT Name,NumberSold FROM PRODUCT ORDER BY NumberSold LIMIT 10Also, I only want 10 returned if that's possible.
Thanks in advance.
Eric Stewart[/quote]
Moderator: General Moderators
Code: Select all
SELECT Name,NumberSold FROM PRODUCT ORDER BY NumberSold LIMIT 10Code: Select all
SELECT Name,NumberSold FROM PRODUCT ORDER BY NumberSold DESC LIMIT 10