select top 3 <column_name> from ,table

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

Question Posted / krishna sandeep

Answer Posted / krishna sandeep

select top 3 <column_name> from ,table_name> order by
<column_name> desc

this will work.

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Which are new data types introduced in sql server 2008?

1042

When would you use it?

988

What is the difference between truncate and delete commands?

1062

What is the Main Difference between ACCESS and SQL SERVER?

1126

How do I install only the client tools of sql server 2000?

1062

What is a join in sql?

1082

What is meant by datasource?

919

can a table be moved to different filegroup? : Sql server administration

968

What is filter index?

949

Explain throw statement in sql server 2008?

985

what is the sql equivaent of the dataset relation object ?

2019

What are parameterized reports? What are cascading parameters in ssrs reports?

156

What is difference between after and before?

1077

Explain what is lock escalation and what is its purpose?

926

What are the restraints imposed on the table design by a merge replication?

1033