wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / balaji
select * from table_name ORDERBY id DESC limit 0,n;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does transparent data encryption provide encryption when transmitting data across the network?
What is a result set object returned by odbc_exec()?
Can we install sql server 2016 on windows 7?
Where the sql logs gets stored? : sql server database administration
What is full outer join in sql server joins?
What are scalar functions?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Difference between Inner vs outer joins?
What is a trigger? Why we need it?
What is openrowset sql server?
How to find the version of sql server? : sql server database administration
What are logical database components? : SQL Server Architecture
What is the difference between a function and a stored procedure?
What is the language structure to add a record to a table?
What is difference between view and materialized view?