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

How to backup SQL Server Reporting Services ?

152

1 01 101 01010

2098

What is the purpose of data source?

1087

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1070

How to return the date part only from a sql server datetime datatype?

1162

What is a dataset and what are the different types of datasets?

141

What is the difference between primary key and unique constraints?

1007

What are the new security features added in sql server 2012? : sql server security

1105

How can we get count of the number of records in a table?

996

Explain magic tables in sql server?

1100

What is user-defined scalar function?

1007

Can we insert data into view sql server?

981

What are sql servers used for?

1111

Please differentiate between a local and a global temporary table?

1058

What types of replication are supported in sql server?

1111