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

What are the new features are introduced in sql server 2012 reporting services?

160

What is sqlservr.exe - process - sql server (sqlex?press)?

1152

What is sqlcmd?

1134

do views contain data ?

1018

What is difference between getdate and sysdatetime in sql server 2008?

1097

what is isolation level at dead lock?

2209

What is statement level trigger?

1045

Difference between DELETE and TRUNCATE?

1094

What are the benefits and tasks of object explorer? : sql server management studio

1250

How can you ensure that the database and sql server based application perform well?

1119

Explain full-text query in sql server?

1053

What is the use of =,==,=== operators?

1057

What happens if the update subquery returns no rows in ms sql server?

1173

Difference between report and query parameter.

1141

What is resultset concur_updatable?

1053