select top 3 * from tablename order by 1 desc By Kumar Junior Softwar

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

Question Posted / kumar

Answer Posted / kumar

select top 3 * from tablename
order by 1 desc

By
Kumar Junior Software Engineer

Is This Answer Correct ?

13 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain what is log shipping?

1134

Define magic tables in sql server?

1053

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1029

What is the difference between for auto and for nested?

1001

What is the difference between commit and rollback?

941

How is foreign key related to primary key?

969

What is dbcc updateusage?

1201

Create and insert into temp table in sql server?

1028

Do you know what is openxml in sql server?

1068

How can we determine what objects a user-defined function depends upon?

1005

What is an indexing strategy?

1005

Explain syntax for dropping triggers?

927

What are subqueries in sql server?

1120

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1020

What is the meaning of resultset type_scroll_insensitive?

952