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

What is a view in sql?

926

How to set database to be read_only in ms sql server?

954

What different steps will a sql server developer take to secure sql server?

927

What is sql server 2000 work load governor?

975

Explain relational data?

854

Does index slows down insert statements?

936

Explain an automatic checkpoint

913

Which sql server is best?

952

What are the different types of lock modes in sql server 2000?

881

How to create a large table with random data for index testing in ms sql server?

977

What happens if you add a new index to large table?

881

What is spid in sql server profiler?

1025

What language is sql server written in?

984

Do you know what are the properties of the relational tables?

981

What is an execution plan?

1055