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

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1319

how you can deploy an ssrs report?

185

How do you handle datasets larger than 50 gb?

164

What is the downside of using udf?

1161

What is indexed view?

1025

Write an sql query for deleting duplicate rows?

1037

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1151

What are the Advantages of using CTE in sql server?

1166

How to copy data from one table to another table?

1051

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1132

Introduction of rollup clause using sum and group by clause?

1011

What is difference between standardization and normalization?

1159

What are the steps to insert a table?

991

How do I get to sql server configuration manager?

1059

What is the difference between Normalization and De-normalization?

1143