English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2006-09-19 22:40:52 · 4 answers · asked by raju s 1 in Computers & Internet Programming & Design

4 answers

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

fedest.com, questions and answers