drop table #temp select identity(int,1,1) as SlNo, * into #temp from TABL

wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records

Question Posted / arun kumar k s

Answer Posted / arun kumar k s

drop table #temp select identity(int,1,1) as SlNo, * into
#temp from TABLE_NAME select top 3 * from #temp order by
SlNo desc

arun_4454@yahoo.co.in

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain how to send email from sql database?

973

What is data source in connection string?

850

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1007

What the different components in replication and what is their use?

913

How to access the deleted record of an event?

976

Can you explain what is sql server english query?

948

What do you think of this implementation? Can this be implemented better?

875

How to list all login names on the ms sql server?

1079

Explain how you can deploy an SSRS report?

137

How to override dml statements with triggers?

1070

Describe the functionalities that views support.

1050

What are the new features in sql server 2016?

929

How to encrypt Strored Procedure in SQL SERVER?

1097

How do I determine how many instances of sql server are installed on a computer?

958

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1006