select top 3 from <table name > where < specify any condition>

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

Question Posted / priya

Answer Posted / priya

select top 3 from <table name > where < specify any
condition> order by <column ID> desc

Is This Answer Correct ?

15 Yes

16 No

Please Help Members By Posting Answers For Below Questions

How would you add a section to a table?

1012

What is the difference between mysql and sql server?

994

What stored procedure can you use to display the current processes?

873

What is the simplest way to create a new database in ms sql server?

989

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

977

How to rebuild the master database?

1065

How to list all objects in a given schema?

1037

What is merge replication?

1091

List the different types of collation sensitivities in sql server?

1030

Explain active/passive and active/active cluster configurations?

1046

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2058

New concepts of sql server 2005 use in your project.

2346

What the different components in replication and what is their use?

936

Explain the etl (extraction, transformation, and loading)?

979

What is a periodical index?

903