wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / teja
select * from employee where emp_id in
(select top 3 emp_id from employee order by emp_id DESC)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you make a trace?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
difference between Clustered index and non clustered index ?
How many types of cursor type are there?
How to replace the Query Result 'Null Value' with a text ?
What are trace files?
role of sql sever 2005 in database rather than any other database
When we should use @@error?
Explain what are various ways to enhance the ssrs report?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Explain go command in sql server?
What is an example of a foreign key?
How to rebuild all indexes on a single table?
What is standby servers? Explain types of standby servers.
Can sql server 2016 run on windows 7?