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

How can we rewrite sub-queries into simple select statements or with joins?

602

What are different types of views?

627

What are the different sql server versions?

594

What is a field name?

615

What is the query and subquery?

703

What is clr ddl trigger?

633

Is sql server free?

599

What does Master database contains?

711

Relational calculus is what type of language?

674

What is nonclustered index on computed columns?

646

Can you explain important index characteristics?

611

What is xdr?

663

Why functions are used in sql server?

590

What different steps will a sql server developer take to secure sql server?

600

What is default constraint in ms sql server?

620