Limit problem
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?
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.