wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / lakram5455
SELECT TOP(3) * FROM emp ORDER BY EId DESC
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the differences between union, intersect, and minus operators?
Why we should not use triggers?
What is the new security features added in sql server 2016? : sql server security
What are the triggers in sql?
Define left outer join?
Differentiate between a local and a global temporary table?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is public role in sql server?
How to use union to merge outputs from two queries together in ms sql server?
What is Command line parameters in PLSQL.?
How to use the inserted and deleted pseudo tables?
What are the differences between having and where clause.
How to encrypt data between dialogs?
Tell me what is log shipping?
What is replace and stuff function in sql server?