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 the difference between stored procedure and user defined functions?

1233

What is table valued function and scalar valued functions?

1160

How to set the current database in ms sql server?

1139

What are constraints?

1058

What is “asynchronous” communication in sql server service broker?

1076

Describe and explain about SQL native client?

1155

What are the advantages of sql azure?

140

Can group by be used without aggregate functions?

965

Explain user defined functions?

1045

What is a transactions?

1082

What are date and time data types in ms sql server?

1158

How to add more data to the testing table in ms sql server?

1162

What is model database in sql server?

1101

Is mysql better than sql server?

1106

What is difference between stored procedure and user defined function?

1168