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

write an SQL query to list the employees who joined in the month of January?

1624

How to create user defined functions with parameters?

1166

How can a user-defined datatype be created?

937

Explain “not null constraint” in sql server?

958

how you can get the list of largest tables in a database? : Sql server administration

988

What is NOT NULL Constraint in sql server 2012?

936

What is data compression?

943

You want to implement the many-to-many relationship while designing tables. How would you do it?

956

what is difference between NULL and ISNULL in SQL Server 2008?

967

What is difference between index seek vs. Index scan?

1098

How to Sync Two SQL Azure Databases?

119

How to replace null values in expressions using isnull()?

1052

What is stored in the mssqlsystemresource database? : sql server database administration

988

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

884

Can two tables share the same primary key?

858