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

Can we insert data into view sql server?

981

Is oracle faster than sql server?

1004

What structure can you implement for the database to speed up table reads?

1231

What is a cursor, index in sql?

1126

How to list all triggers in the database with sys.triggers in ms sql server?

1123

Explain primary key and foreign key constraints?

1089

Do you know how to implement service broker?

965

How can you start sql server in different modes?

1019

How do I uninstall sql server 2014?

985

What is the difference between a primary key and a unique key? Are they the same?

1119

How to bind a view to the schema of the underlying tables?

1046

What is the difference between SQL notification and SQL invalidation?

1262

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1030

Which data type columns are the best candidates for full-text indexing?

1022

How to change the name of a database user?

1007