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
- 30361 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
List out some of the requirements to set up a sql server failover cluster?
What is the maximum size of column in sql server?
What are triggers in ms sql server?
What are tables in sql server?
Explain about thread and memory management process of SQL?
What is temporary stored procedure?
What are the different types of normalization?
Difference between report and query parameter. Why do we need different type of parameter?
When is update_statistics command used?
What are the advantages of having an index on the sql server?
Explain full-text query in sql server?
What is a recursive stored procedure in sql server?
where can you add custom error messages to sql server? : Sql server administration
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Is BCNF better than 2NF & 3NF? Why?
