Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 30288 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 do you understand by replication in sql server? Mention the different types of replication in sql server.
Can you pass expressions to stored procedure parameters?
Why use identity in sql server?
how you can deploy an ssrs report?
Explain how to maintain a fill factor in existing indexes?
Explain what you mean by 3 tier architecture.
What are subquery and its properties?
How you can add messages to the nt event log from within a stored procedure?
How are the unique and primary key constraints different?
What is it’s similarity with sql server?
What is user-defined function?
How to connect Azure federated root database and apply federation in entity framework?
List the types of recovery model available in sql server?
Why is the need for data conversion transformations?
What is create statement?
