how to retrive only second row from table in sql server 2000?

how to retrive only second row from table in sql server
2000?

Question Posted / ravi148

3 Answers
7405 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to retrive only second row from table in sql server 2000?..

Answer / swagata mukherjee

Select < fields names > from <table name > Limit 1,1

Is This Answer Correct ?

0 Yes

0 No

how to retrive only second row from table in sql server 2000?..

Answer / nagapawan

eg:

select top2 * from tablename
this table retrive only second row only

from 2nd row if u want only number and name

then like this we have to write
eg:
select top2 empno,ename from emp

Is This Answer Correct ?

0 Yes

4 No

how to retrive only second row from table in sql server 2000?..

Answer / prakash t

Here you go,

for example , consider one EPmloyee table , to get a 2nd
row :

General syntax :

Select < fields names > from <table name > where rownum
= <row ID>

Ex : select Ename , Eid , Designation from Employee where
rownum=2

Is This Answer Correct ?

1 Yes

6 No

Post New Answer