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

Will sql server 2005 allow you to reduce the size of a column?

992

Explain about remote stored procedure?

1008

What stored by the msdb? : sql server database administration

1003

how will add additional conditions in sql?

1107

Can a table have 2 foreign keys?

905

How do I connect to sql server database?

1014

Why do we need different type of parameter?

1057

Can we use pragma autonomous_transaction in trigger?

962

in the physical file layout, where should the transaction log be stored in relation to the data file?

994

Can we add an identity column to decimal datatype?

1002

What does ss stand for sexually?

1086

Can you import Microsoft Excel data to SSRS?

132

How to replace given values with null using nullif()?

991

What is the difference between clustered and a non-clustered index?

1029

What is replace and stuff function in sql server?

1067