drop table #temp select top 2 identity(int,1,1) as SlNo, * into #temp fro

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

Question Posted / arun kumar k s

Answer Posted / arun kumar k s

drop table #temp select top 2 identity(int,1,1) as SlNo, *
into #temp from TABLE_NAME select * from #temp where SlNo=2

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to add an address record into adventureworkslt?

572

What's new in sql management studio for sql server? : sql server management studio

584

How to delete exactly duplicate records from a table?

606

Explain the steps to create and execute a user-defined function in the sql server?

532

How to generate create function script on an existing function?

596

How to copy data from one table to another table?

546

Explain throw statement in sql server 2008?

583

What is store procedure? How do they work?

583

What is database black box testing?

609

Explain an automatic checkpoint

563

Is sql server free?

526

What are dml (data manipulation language) statements in ms sql server?

556

How to use linked server?

593

What command would you use to add a column to a table in sql server?

753

What are the advantages of the mirroring?

574