It depends upon the database engine. Including the row number in the result set is not part of the SQL standard, each database vendor tends to do it differently.
What database are you using? Oracle, MySQL, Postgres, DB2, SQL Server, ...
2006-09-22 05:54:25
·
answer #1
·
answered by Jeff Alexander 2
·
0⤊
0⤋
Raju sorry mate cant understand what you need but here is the link see if it can help you.
http://www.google.co.uk/search?hl=en&q=row+no+in+sql+queries&btnG=Google+Search&meta=
2006-09-20 05:44:31
·
answer #2
·
answered by Joe_Young 6
·
0⤊
0⤋
u can print row number with every row returned by the sql select statement by using "rownum" in a select statement.
select rownum, emp_id, emp_name
from
emp;
2006-09-20 06:05:13
·
answer #3
·
answered by zabi150 2
·
0⤊
0⤋
Please see http://www.adp-gmbh.ch/ora/sql/rownum.html
In a software developer interview one of the favrt questions asked by interviewers is to find out the third or fourth highest salary
the above suedo keyword helps to find dat
2006-09-20 05:49:46
·
answer #4
·
answered by funky_dude 2
·
0⤊
0⤋