Hi, select top 1 * from (SELECT TOP 2 * from emp) A Order by empno des

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

Question Posted / suresh

Answer Posted / suresh

Hi,

select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc

Is This Answer Correct ?

16 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Is it possible to update the views? If yes, how, if not, why?

1031

What are different types of collation sensitivity?

991

Do comments need to go in a special place in sql server 2005?

862

whats the maximum size of view state??

2193

What is a dbms wizard?

1027

How can you hide the sql server instances?

1025

What is transact-sql ddl trigger?

1113

What is TDS(Tabular Data Stream) Gateway?

121

How to list all tables in the database using odbc_tables()?

1052

How global temporary tables are represented and its scope?

979

what method you can use to reduce the overhead of Reporting Services data sources?

255

What is the chart in report?

161

What is a collation?

1098

What is the difference between TRUNCATE and DROP?

1146

Mention the differences between having and where clause.

1065