Returning results in the order of 'most results first'
Posted: Tue Dec 06, 2005 12:14 pm
Well, the subject made no sense 
Anyway, let's say I had a forum, which, in the 'posts' table, lists the text, and the poster id.
I want to see who has made the most posts, so I need to fetch a list of the poster id's, ordered by the amount of times they are in the table.
And that's where my SQL skills fail me. All I can do is 
Anyway, let's say I had a forum, which, in the 'posts' table, lists the text, and the poster id.
I want to see who has made the most posts, so I need to fetch a list of the poster id's, ordered by the amount of times they are in the table.
And that's where my SQL skills fail me. All I can do is
Code: Select all
SELECT * FROM women WHERE attracted_to = 'Grim...' ORDER BY boob_size DESC