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 many partitions a clustered index has by default in sql server 2012?

661

What is a data source file?

499

What is the new security features added in sql server 2016? : sql server security

618

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

116

How to modify existing triggers using "alter trigger"?

530

What are data regions?

What is ddl and dml commands?

509

What are distributed partitioned views?

623

What is the latest version of microsoft sql server?

488

Explain cross join or cartesian product in sql?

544

What are the reporting services components?

Can we use custom code in ssrs?

587

How to end a stored procedure properly in ms sql server?

550

What is transact-sql ddl trigger?

633

What are filegroups in sql server?

581