Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 29787 Views
- I also Faced
- E-Mail Answers
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
What is a user-defined function in the sql server and what is its advantage?
Explain the Ways to improve the performance of a sql azure database?
Why do you need a sql server?
What is awe?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are parameterized reports?
How do you create a data source?
Write a query to find 5th highest amount paid from the customer table.
Explain indexed views?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is database white box testing?
How do clustered indexes store data?
Explain a join?
what are acid properties? : Sql server database administration
Why are you getting errors when creating a new odbc dsn?
