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

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

923

How to specify the collation for a character data type in ms sql server?

1026

Explain about Joins?

988

query processing

2162

What are various aggregate functions that are available?

978

Can we hide the definition of a stored procedure from a use?

1220

Difference between Logical Page and Physical Page in SSRS.

476

How to create new databases with "create database" statements?

1017

What is a subquery in a select query statement in ms sql server?

1131

What are the differences between web role and worker role?

122

Explain optimistic and pessimistic concurrency?

991

How check triggers in sql server?

990

Explain about thread and memory management process of SQL?

971

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1262

What are the two authentication modes in sql server?

1117