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

What are the limitations in ssrs on sql server express edition?

186

Which are ddl commands?

1046

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1010

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

1028

What are the fixed server level roles? : sql server security

1128

What is the order by used for?

1024

What do you mean by subquery?

1087

Explain different types of self contained sub query?

1036

How to rename databases in ms sql server?

1201

Can sql server 2016 run on windows 7?

916

What are cursors stored procedures and triggers?

1019

Explain in brief about Microsoft SQL server?

1094

Describe and explain about SQL native client?

1108

Show Practically Sql Server Views are updatable?

1123

What is the sql profiler?

940