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
What is the sql server 2000 version number?
What is a dataset and what are the different types of datasets?
How do I view a script in sql server?
Can you import Microsoft Excel data to SSRS?
What is the difference between upgrade and migration in sql server?
What is tablesample?
What is 1nf 2nf?
What are the differences between stored procedure and the dynamic sql?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What happens when transaction log is full?
How do you start single user mode in clustered installations?
Explain the properties of sub-query in sql server?
What is filter index?
What is sql language?
What are the various editions of sql server 2017 that are available in the market?