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

Where views are stored in sql server?

991

How to transfer a table from one schema to another?

1004

Do you know clustered and non-clustered index?

979

What is the purpose of indexing?

1046

Mention the differences between local and global temporary tables.

1046

When would you use it?

999

Explain the different types of joins?

997

explain databases and sql server databases architecture? : Sql server database administration

966

What is merge replication?

1109

What is @@error in sql?

1070

What is a domain constraint give an example?

1049

Why use cursor in sql server?

1082

What are the different index configurations a table can have?

961

What is the difference between ddl,dml and dcl commands?

1114

How to remove duplicate rows from table except one?

1014