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

Does transparent data encryption provide encryption when transmitting data across the network?

1051

What is a result set object returned by odbc_exec()?

1032

Can we install sql server 2016 on windows 7?

1142

Where the sql logs gets stored? : sql server database administration

970

What is full outer join in sql server joins?

1073

What are scalar functions?

1002

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

909

Difference between Inner vs outer joins?

954

What is a trigger? Why we need it?

1000

What is openrowset sql server?

1136

How to find the version of sql server? : sql server database administration

1115

What are logical database components? : SQL Server Architecture

1042

What is the difference between a function and a stored procedure?

1075

What is the language structure to add a record to a table?

1025

What is difference between view and materialized view?

940