wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
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 |
Post New Answer View All Answers
Explain how to send email from sql database?
What is data source in connection string?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What the different components in replication and what is their use?
How to access the deleted record of an event?
Can you explain what is sql server english query?
What do you think of this implementation? Can this be implemented better?
How to list all login names on the ms sql server?
Explain how you can deploy an SSRS report?
How to override dml statements with triggers?
Describe the functionalities that views support.
What are the new features in sql server 2016?
How to encrypt Strored Procedure in SQL SERVER?
How do I determine how many instances of sql server are installed on a computer?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration