Top Ten Results
Posted: Mon Nov 11, 2002 2:25 pm
I'm trying to write a mysql command that will find the top ten, and only the top ten results from a search. Here is the code i tried:
What I want is the top ten sold items, what Im getting is the first 10 items in that tables ordered by number of sold.
Also, I only want 10 returned if that's possible.
Thanks in advance.
Eric Stewart[/quote]
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]