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 drillthrough reports?

155

What is the main purpose of having conversation group?

894

What is read committed?

1072

How to enter binary string literals in ms sql server?

1137

What is the tcp/ip port on which sql server runs?

1140

How do I perform an unattended install of sql server 2000?

1070

What type of locking occurs during the snapshot generation? : sql server replication

1324

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1097

What is the sql case statement used for? Explain with an example?

984

What is the command used to check locks in microsoft sql server?

1037

Explain relational data?

906

How do I create a stored procedure in dbml?

994

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1031

Do you know concepts and capabilities of sql server?

1050

What are diverse clauses that form a part of sql?

1062