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 is an execution plan?

1056

What is the difference between a fill factor of 100 and 0?

920

Would you store your query in a ssrs report or a database server? State the reason why?

148

How do I start sql server 2017?

887

Can a rule be bound to any column of any data type?

911

When columns are added to existing tables, what do they initially contain?

976

Differentiate between delete and truncate.

994

What is data compression? : sql server database administration

917

Explain indexed views and partitioned view with their syntax.

1077

What is serializable?

996

Can you explain what is the use of custom fields in report?

1000

What does sql server mean?

974

What are partitioned views and distributed partitioned views?

977

What is use of dbcc commands?

1017

What is inline table-value user-defined function?

1011