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

What is RAID? What are the different types of RAID configurations?

1063

What causes index fragmentation?

936

Can we check locks in database? If so, how can we do this lock check?

893

Can you import Microsoft Excel data to SSRS?

124

What are the new features of sql server 2012 reporting service?

123

what is normalization? Explain different levels of normalization? : Sql server database administration

1210

What is the difference between Triggers and Stored Procedure?

1031

What is @@error in sql?

1021

What is amo? : sql server analysis services, ssas

1044

What are the requirements to use odbc connections in php scripts?

1058

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

909

What is partition in sql server?

973

What stored by the model?

981

Can we use pragma autonomous_transaction in trigger?

910

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2424