MySQL Forums
Forum List  »  Newbie

Limit problem
Posted by: vidar nordbrenden
Date: May 04, 2005 02:24PM

I want to make a top 3 lists from a table with a query like this
SELECT points FROM table ORDER BY points LIMIT 0,3

This will of course return a list of the 3 lowest values of points in the table, lets say 1,2,3.

Now to my problem...
If several records in the table has 3 points I want to have all those records returned, lets say 1,2,3,3,3

In MS Access this can be solved by SELECT TOP 3 from.......

Any ideas how to get around this?

Options: ReplyQuote


Subject
Written By
Posted
Limit problem
May 04, 2005 02:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.