MySQL Forums
Forum List  »  Newbie

retrieve record position
Posted by: Tony David
Date: July 31, 2007 07:26AM

I would like to now if there's any way through mysql to retrieve the position
of a specific record in a query.

My question might be a little confusing but let me explain through an example
Take following example table

ID Name Datum
1 Pierre 2007/07/07
2 Paul 2007/07/06
3 Rubens 2007/07/04
4 Paul 2007/07/05
5 Pattrick 2007/07/17

with following sql
SELECT * order by datum desc

Obviously this the result
5 Pattrick 2007/07/17
1 Pierre 2007/07/07
2 Paul 2007/07/06
4 Paul 2007/07/05
3 Rubens 2007/07/04

What i want to know now is which row,for instance, the name Paul would be found in that result

in this example it would be row 3 and 4

Hope i explained this well enough.
Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
retrieve record position
July 31, 2007 07:26AM


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.