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

Explain some stored procedure creating best practices or guidelines?

523

What are the advantages of sql stored procedure?

540

What are functions in the sql server?

603

How to declare a cursor with "declare ... Cursor" in ms sql server?

569

Write a query for primary key constraint with identity key word?

575

What is an example of a primary key?

511

What is a coalesce function?

667

What is @@rowcount in sql?

565

What new changes are being made in SQL Server?

574

what stored procedure can you use to display the current processes? : Sql server administration

528

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

488

How to backup encryption key ?

127

Define union, union all, minus, intersect?

571

what is a mixed extent? : Sql server administration

604

Explain the collation?

624