wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27300 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijaykumar dolli
Select * From Sample Where
Srno In (Select Top 3 srno From Sample Order By 1 Desc)
-- Sample is a Table Name and Srno is Unique Key column
-- This is the perfect Answer ...!
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are different type of Collation Sensitivity?
Do you know what are acid properties of transaction?
How each E-R model constructs can be mapped to the relational model?
What happens if you are trying to access a schema not owned by you?
What is the name of the Database which IBM mainframe uses?
How do I create a stored procedure in dbml?
How to view the error log for any specific instance? : sql server database administration
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the difference between a fill factor of 100 and 0?
What is conditional split?
Which are the olap features?
What is a select query statement in ms sql server?
Why do we partition data?
What is ms sql server reporting services?
