MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Predicting SORT BY
Posted by: Felix Geerinckx
Date: April 28, 2005 01:46AM

Brian Gordon wrote:

> So basically if I had a database of names and their incomes, I would need to find the name that
> has the 10000th highest income.

You want to use the LIMIT clause.
You can read about it here: http://dev.mysql.com/doc/mysql/en/select.html

--
felix

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Predicting SORT BY
Brian Gordon
April 27, 2005 04:09PM
Re: Predicting SORT BY
Felix Geerinckx
April 28, 2005 01:46AM
Re: Predicting SORT BY
Brian Gordon
May 02, 2005 04:38PM
Re: Predicting SORT BY
Brian Gordon
May 02, 2005 04:40PM
Re: Predicting SORT BY
Felix Geerinckx
May 03, 2005 12:45AM


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.