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

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

Question Posted / grace

Answer Posted / grace

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

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why do you want to join software field as you have done your BE in Electronics?

1889

What is log in sql server?

759

What is lookup override?

768

What are the security related catalog views? : sql server security

703

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

831

Why do we use stored procedures in sql server?

677

What is nonclustered index with included columns ?

709

What is blocking?

716

What is entity data services?

780

Why do we need different type of parameter?

747

What is the difference between mysql and sql server?

652

How to define and use table alias names in ms sql server?

744

What is a full text index?

667

What is SQL Server?

844

Explain what are sparse columns?

745