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

Explain relational data?

906

Why truncate is ddl command?

1054

What is subquery? Explain the properties of a subquery?

977

Is sql server a database?

981

How to locate and take substrings with charindex() and substring() functions?

1008

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1052

what's new in sql server 2016?

945

Why we should not use triggers?

959

What is the report builder?

139

Why use stored procedures in sql server?

1000

Can you explain various data region available in ssrs with their use?

968

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1008

How to use group functions in the select clause in ms sql server?

1046

Write a sql query to get zero records from a table having n number of records?

1172

Explain what is cte (common table expression)?

1119