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
How do you delete duplicate rows in sql server?
How to throw custom exception in Stored Procedure?
Why are sql functions used?
Why transaction is important?
What are drilldown reports?
How to choose all records from the table?
What is the default order of an order by clause?
What is the difference between seek predicate and predicate?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Tell me what is fill factor?
Tell me can we use custom code in ssrs?
explain how to create a new schema in a database? : Sql server database administration
Describe the left outer join & right outer join. : sql server database administration
How do I manually uninstall an instance of sql server 2016?
What is filestream?