select min(id) from cms_dfm where id in (SELECT TOP 2 ID from CMS

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

Question Posted / shashikant

Answer Posted / shashikant

select min(id) from cms_dfm where id in (SELECT TOP 2 ID
from CMS_DFM Order by
ID desc)

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is dbcc updateusage?

537

What is difference between equi join and natural join?

543

What is the guest user account in sql server? What login is it mapped to it? : sql server security

587

What is difference between views and stored procedures?

516

What are sparse columns?

586

What is dirty page?

568

What is stored procedures?

548

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

What is the use of toad or sqldbx.?

726

What purpose does the model database server?

657

How to choose all records from the table?

657

What is the downside of using udf?

563

What are the different Authentication modes in SQL Server and how can you change authentication mode?

644

How to execute stored procedure and set temp table in sql server?

560

What do you understand by integration services in sql server?

553