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 does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1056

What is the difference between mysql and sql server?

1020

How can we solve concurrency problems?

1051

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1093

Can a rule be bound to any column of any data type?

961

How to loop through result set objects using mssql_fetch_array()?

1074

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1159

What is an etl file?

953

where the connection string store in the database

2069

What are page splits?

995

Explain the microsoft sql server delete command?

1018

Explain user defined functions?

987

What is the boxing and unboxing concept in .net?

915

What are the different types of indexes?

1114

Explain atomicity?

1046