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

Explain sql server authentication modes?

597

What is tabulation?

549

Can we update data in a view?

592

Tell me what is the difference between locking and multi-versioning?

573

What is the full form of ddl?

497

Is sql server 2016 free?

524

How to rename databases in ms sql server?

616

What are the encryption mechanisms in sql server?

566

How to list all dsn entries on your local machine using odbc_data_source()?

550

What is the default sql server instance name?

551

What is oltp (online transaction processing)?

577

What is tablesample?

564

What is difference between view and materialized view?

527

Define inner join in sql server joins?

528

What do you understand by mirroring?

558