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
What is proper subset of candidate key?
Why is the need for data conversion transformations?
What are two difference between sql azure and azure tables?
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?
explain extended properties
What are security principals used in sql server 2005?
Explain Capacity planning to create a database? and how to monitor it?
Define left outer join in sql server joins?
What are the different types of locks in the database?
How to read data in a table with "select" statements?
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?
What are cursors stored procedures and triggers?
What is table constraint?
What is triggers and stored procedures?
What is the security principal at the server level that represents your session?