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

Explain a join?

694

What is the maximum number of index per table?

659

Explain what is scheduled job and how to create it?

636

How to write a query with a right outer join in ms sql server?

563

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

656

What is the most common type of join?

625

Is null vs coalesce?

578

What is store procedure? When do you use?

606

What is the difference between left and right outer join?

620

In what version of sql server were synonyms released?

593

How do I determine how many instances of sql server are installed on a computer?

618

How you provide security to cube? : sql server analysis services, ssas

636

What is analysis service repository?

679

How to connect of datebase with sql express.?

731

Distinguish between nested subquery and correlated subquery?

633