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

Delete duplicate rows without using rowid.

1587

How check triggers in sql server?

1050

How to find the source of a table in sql server?

1037

How to find the login name linked to a given user name?

1060

Can sql servers link to other servers?

1139

What is the significance of null value and why should we avoid permitting null values?

1034

What is the default order of an order by clause?

1035

What are the different sql server versions?

1033

What is indexing a document?

1090

What does set rowcount do?

961

What is the recovery model? List the types of recovery model available in sql server?

947

What is nonclustered index on computed columns?

1000

What the different topologies in which replication can be configured?

1144

How to get the query of a table in sql server?

962

What are the steps you should follow to start sql server in single-user mode?

952