wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27302 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
Can you explain important index characteristics?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Why we need sql server?
Explain raiserror in sql server?
What is a result set object returned by odbc_exec()?
what are the different types of SSRS reports?
How can we rewrite sub-queries into simple select statements or with joins?
What happens when converting big values to integers?
What are different types of replication in sql server?
What happens if date-only values are provided as date and time literals?
What are the different types of backups that exist?
What are the different types of sql server replication? : sql server replication
whats new about truncate in sql server 2008?
How can you append an identity column to a temporary table?
What is the command to change the recovery model?
