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
- 29781 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 the simplest way to create a new database in ms sql server?
What is rolap and its advantage? : sql server analysis services, ssas
List out some of the requirements to set up a sql server failover cluster?
How to enforce security in sql server? : sql server security
Explain the steps needed to create a scheduled job?
Explain primary key?
How can we migrate from SQL server to SQL Azure?
What is exclusive locks?
What is meant by referential integrity?
Which autogrowth database setting is good?
How do we Backup SQL Azure Data?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Do you know sql server 2008 backup compression?
What is the difference between Triggers and Stored Procedure?
Where do we use trace frag?
