select top 1 * from xyz where rno > (select top 1 rno from xyz) rno i

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

Question Posted / prabhat sharma

Answer Posted / prabhat sharma

select top 1 * from xyz where rno > (select top 1 rno from xyz)

rno is a column name and xyz is a table name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to modify the underlying query of an existing view?

926

Differentiate between mongodb vs. Sql server?

1028

How do you send email on SQL Server?

998

How is SQL Azure different than SQL server?

223

Explain the usage of floor function in sql server.

912

What are the limitations in ssrs on sql server express edition?

175

where the connection string store in the database

2014

What is collation sensitivity?

982

In which sql server version report builder introduced?

142

What is similarity and difference between truncate and delete in sql?

1027

Why truncate is ddl command?

992

How do you troubleshoot errors in a SQL Server Agent Job?

1005

Explain what are the database objects? : SQL Server Architecture

1001

Where can you find the error log information? : sql server database administration

970

How many non clustered indexes there can be on table ?

860