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 is dbcc updateusage?

1203

How to create a simple user defined function in ms sql server?

1021

What are the basic functions for master, msdb, model, tempdb and resource databases?

987

Explain what are magic tables in sql server?

997

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

1052

What are the main sources of data?

1095

What is primary key and example?

954

What is code near application topology?

279

What is the importance of three tier architecture?

1093

Can an automatic recovery be initiated by a user?

1016

What is the difference between DataRow.Delete() and DataRow.Remove()?

1230

What is database black box testing?

1033

Does group by or order by come first?

958

What are the advantages of stored procedure in sql server?

892

Explain can you implement data mining in ssrs?

158