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

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1100

what is a live lock? : Sql server database administration

1021

What is difference between count (*) and count column?

950

What is difference between rownum and rowid?

958

Explain how to use linked server?

1033

Why should we go for stored procedures? Why not direct queries?

1158

What are subquery and its properties?

1105

What is transaction server explicit transaction?

1089

Where are full-text indexes stored?

1037

what changed between the previous version of sql server and the current version? : Sql server database administration

1054

Explain logical operators in sql server?

1184

Does the unique constraint create an index?

1137

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2414

What are the tables in sql?

1152

You want to implement the one-to-one relationship while designing tables. How would you do it?

1017