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
How does stuff differ from the replace function?
What are the steps to insert a table?
Where sql server usernames and passwords are stored in a sql server?
What is the latest version of microsoft sql server?
How do I find query history in sql server?
What is b tree index?
What is snapshot report?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What are the restrictions that views have to follow? : SQL Server Architecture
Explain rdbms?
How to retrieve error messages using odbc_errormsg()?
What are dml triggers and types of dml triggers?
What is sql server used for?
What is the difference between a local and a global temporary table?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration