wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / kumar
select top 3 * from tablename
order by 1 desc
By
Kumar Junior Software Engineer
| Is This Answer Correct ? | 13 Yes | 6 No |
Post New Answer View All Answers
What are data regions?
Can we write a distributed query and get some data which is located on other server and oracle database?
How to generate create procedure script on an existing stored procedure?
What are the steps you will take to improve the performance of a poor performing query?
Does partitioning improve performance?
What stored by the tempdb ? : sql server database administration
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is user defined stored procedures?
Explain transaction server auto commit?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to perform key word search in tables?
Explain what are various ways to enhance the ssrs report?
What is the latest version of microsoft sql server?
Explain about SQL server 2005?
What is difference between oltp and olap?