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

Answer Posted / grace

SELECT TOP 3 * FROM <TABLE_NAME> WHERE <CONDITION> ORDER BY
<COLUMN_NAME> DESC

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is proper subset of candidate key?

528


Why is the need for data conversion transformations?

477


What are two difference between sql azure and azure tables?

135


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

526


explain extended properties

546






What are security principals used in sql server 2005?

497


Explain Capacity planning to create a database? and how to monitor it?

3728


Define left outer join in sql server joins?

532


What are the different types of locks in the database?

465


How to read data in a table with "select" statements?

537


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

846


What are cursors stored procedures and triggers?

498


What is table constraint?

522


What is triggers and stored procedures?

495


What is the security principal at the server level that represents your session?

536