select * from table_name ORDERBY id DESC limit 0,n;

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

Question Posted / balaji

Answer Posted / balaji

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the differences between local and global temporary tables?

1080

How to change the name of a database user?

960

Which are new data types introduced in sql server 2008?

1049

What are the different types of locks in the database?

923

How can a database be repaired?

987

What is a with(nolock)?

982

Explain candidate key, alternate key, and composite key?

1001

What are the types of user defined functions in sql server?

1049

Create and insert into temp table in sql server?

1028

do you know how to configure db2 side of the application? : Sql server database administration

1039

Is it possible to replicate data from sql server to oracle? : sql server replication

1087

What is PROJECTION Operation?

1018

What is Lock table in SQL?

1465

What are temporal tables in sql server 2016?

883

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169