|
|
Posted by Zeeshan on 11/02/05 12:50
Hi everybody,
How can I get rownum using MySQL queries ,
In Oracle one can you in this way SELECT rownum as srno, fname FROM
tablename
suppose If there are 45 records and if i use while for the
srno should display 1, 2, 3, ... 45
query like SELECT rownum as srno, fname FROM tablename
I dont want to use php counter, i want it from query
Reagrds
Friend
Navigation:
[Reply to this message]
|