MySQL Forums :: General :: Record Position in Ordered Selection


Advanced Search

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


Subject Written By Posted
Record Position in Ordered Selection Alan Little 06/05/2009 03:53PM
Re: Record Position in Ordered Selection Peter Brawley 06/06/2009 11:14AM
Re: Record Position in Ordered Selection Alan Little 06/07/2009 07:05AM
Re: Record Position in Ordered Selection Rick James 06/07/2009 10:48AM
Re: Record Position in Ordered Selection Alan Little 06/08/2009 04:53AM
Re: Record Position in Ordered Selection Peter Brawley 06/08/2009 02:21AM
Re: Record Position in Ordered Selection Alan Little 06/08/2009 05:11AM
Re: Record Position in Ordered Selection Peter Brawley 06/08/2009 10:18AM
Re: Record Position in Ordered Selection Alan Little 06/08/2009 11:17AM
Re: Record Position in Ordered Selection Peter Brawley 06/08/2009 12:10PM
Re: Record Position in Ordered Selection Alan Little 06/09/2009 04:20AM
Re: Record Position in Ordered Selection Peter Brawley 06/09/2009 11:28AM
Re: Record Position in Ordered Selection Alan Little 06/09/2009 01:03PM
Re: Record Position in Ordered Selection Rick James 06/06/2009 05:43PM


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.