select top 3 * from tablename order by 1 desc By Kumar Junior Softwar

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

Question Posted / kumar

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

Please Help Members By Posting Answers For Below Questions

What are data regions?

136

Can we write a distributed query and get some data which is located on other server and oracle database?

1233

How to generate create procedure script on an existing stored procedure?

1012

What are the steps you will take to improve the performance of a poor performing query?

980

Does partitioning improve performance?

981

What stored by the tempdb ? : sql server database administration

1053

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

910

What is user defined stored procedures?

949

Explain transaction server auto commit?

1044

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080

How to perform key word search in tables?

964

Explain what are various ways to enhance the ssrs report?

1045

What is the latest version of microsoft sql server?

1048

Explain about SQL server 2005?

983

What is difference between oltp and olap?

1053