wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 26595 Views
- I also Faced
- E-Mail Answers
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
What number sorts of privileges are accessible in sql?
Why use sub query in sql server and list out types of sub queries?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is the difference between a view and a stored procedure?
Can we insert data if clustered index is disabled?
What is the cartesian product of table?
What are the restrictions that views have to follow?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Which data type columns are the best candidates for full-text indexing?
Explain the Ways to improve the performance of a sql azure database?
what is sql server? : Sql server database administration
Define primary key?
What are extended events in sql server?
What is the difference between getdate and sysdatetime?
What is dirty read?
