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

Define full outer join?

894

List the advantages of using stored procedures?

999

Does transparent data encryption provide encryption when transmitting data across the network?

984

What do you mean by an execution plan? How would you view it?

871

Different types of keys in SQL?

1034

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1042

What command is used to create a database in the sql server and how?

1115

How do you rebuild an identity column?

896

How to retrieve error messages using mssql_get_last_message()?

994

Explain what is public role in sql server?

1060

How is table type constraint applied to a table?

936

What is transaction server explicit transaction?

973

Can sql servers linked to other servers like oracle?

904

What is the difference between substr and charindex in the sql server?

1003

What is filtered index?

1046