select top 1 * from(select top 2 * from tbl_test order by 1 asc) as at or

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

Question Posted / lekhraj

Answer Posted / lekhraj

select top 1 * from(select top 2 * from tbl_test order by 1
asc) as at order by 1 desc

Is This Answer Correct ?

24 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what are isolation levels? : Sql server database administration

497

What is executereader?

551

What is a partition key?

521

Explain what are the restrictions that views have to follow? : SQL Server Architecture

593

what is the information that can be stored inside a bit column? : Sql server database administration

522

What is it unwise to create wide clustered index keys?

585

Does sql server 2016 have ssms?

517

What is the Main Difference between ACCESS and SQL SERVER?

559

How can you check the version of sql server?

559

Do you know what are the steps to process a single select statement?

533

what method you can use to reduce the overhead of Reporting Services data sources?

151

Explain the relational database management system (rdbms)?

524

What is delete query?

521

How to send email from database?

579

What are click through reports?