MySQL Forums
Forum List  »  General

Record Position in Ordered Selection
Posted by: Alan Little
Date: June 05, 2009 03:53PM

I have a table with listing IDs, and a rank column which is constantly updated. Given a listing ID I want to find out its position within the top 1,000 records (if it's there at all). Is this possible, or do I have to select those 1,000 records and scan through them?

Options: ReplyQuote

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.