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

Explain candidate key, alternate key, and composite key?

1003

What is a fill factor?

1090

What is the sql server agent?

1093

How do I start sql server 2017?

944

Can foreign key be deleted?

929

How many types of cursor type are there?

1092

What is Federation and Federation Member?

Â Explain what is sql override for a source taLle in a mapping?

1013

What is the latest version of microsoft sql server?

1048

What are sql server functions?

988

Where actually sql azure database is hosted?

163

What is an indice?

1040

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1095

can an automatic recovery be initiated by a user? : Sql server administration

956

List the different types of joins?

1013