select top 1 * from(select top 3 * from tablename order by 1 asc) as at or

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

Question Posted / surenda tarai

Answer Posted / surenda tarai

select top 1 * from(select top 3 * from tablename order by 1
asc) as at order by 1 desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What it means to be triggered?

492

How to identify current user in ssrs report?

238

What is a scheduled job or what is a scheduled task?

533

How efficient you are in oracle and SQL server?

630

What is index, cluster index and nonclustered index?

506

What is an indexed view?

575

What is the use of commit?

535

Call by value and call by reference in procedure and function, with NOCOPY.

827

What does sql server mean?

528

How to rename an existing column with sql server management studio?

494

Can two tables share the same primary key?

494

What is the use of set nocount on/off statement?

619

Explain the commands in sql server?

540

How much is a sql server license?

498

How does Report Builder support Analysis Services cubes?

110