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

If a table does not have a unique index, can a cursor be opened on it?

911

How retrieve field names from the table in SQL through JAVA code?

1900

What are the different types of sql server replication? : sql server replication

1255

Benefits of Stored Procedures?

963

What is clustered primary key?

1008

What is wrong with sql server client libarary dll, ntwdblib.dll?

1033

what is memory-optimized nonclustered indexes

1013

Do you know what is normalization of database? What are its benefits?

1107

How to transfer a table from one schema to another?

993

query processing

2158

How to write character string constants or literals in ms sql server?

1008

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1096

What is difference between delete & truncate commands?

1071

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4372

What is sql azure database?

206