select * from employee where emp_id in (select top 3 emp

wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records

Question Posted / teja

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

Please Help Members By Posting Answers For Below Questions

Why use “pivot” in sql server?

1123

What is open database communication (odbc)?

1067

What is change tracking in sql server?

1030

Mention the 3 ways to get a count of the number of records in a table.

979

What is primary key, unique key, and foreign key?

976

What is GUID in sql server?

1168

What is multi-statement table-value user-defined function?

1000

What is the difference between varchar and nvarchar datatypes?

1091

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

946

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1037

Is it possible to update the views? If yes, how, if not, why?

1031

Can you explain powershell included in sql server 2008?

943

What is read committed?

1095

How do I find the transaction log size in sql server?

964

What does it mean to invest in the index?

974