wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 26596 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 is normalization and its types?
What is row_number()?
How to reaname table name without using sp_Rename in sql server..?
How to create nested stored procedure?
What are the 2 types of classifications of constraints in the sql server?
What is resource governor?
How can sql server instances be hidden? : sql server security
What is the difference between TRUNCATE and DROP?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
How does clustered and non clustered index work?
How can I add Reporting Services reports to my application?
Define cursor locking
Can you name a few encryption mechanisms in sql server?
What is the difference RDBMS and Graph Database?
What are the different types of sql server replication? : sql server replication
