wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
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
Where sql server usernames and passwords are stored in a sql server?
what is memory-optimized nonclustered indexes
What is difference between clustered index and non clustered index?
What is right outer join in sql server joins?
How to sort query output in descending order in ms sql server?
What is use of except clause? How it differs from not in clause?
What is difference between rownum and rowid?
What is dbcc? Give few examples.
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What are relationships and mention different types of relationships in the dbms
What is failover clustering overview?
Can we insert data into view sql server?
What functions can a view be used to performed?
Explain steps of normalization?
How to write a query with a left outer join in ms sql server?