retrieve record position
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
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.