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

How to get the query of a table in sql server?

878

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1066

What is the chart in report?

158

Can you name a few encryption mechanisms in sql server?

926

Explain user defined views?

945

What is a linked server in sql server?

1054

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1158

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1118

What are the essential components of sql server service broker?

1003

How network traffic be reduced by using the stored procedure?

1089

Differentiate between sql temp table vs table variable?

865

What is the standby server?

938

What is user-defined scalar function?

950

Explain database normalization?

1200

What is pivot and unpivot?

997