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
- 30299 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
select top 3 * from tablename
order by 1 desc
By
Kumar Junior Software Engineer
| Is This Answer Correct ? | 13 Yes | 6 No |
Post New Answer View All Answers
Do you know what is replace and stuff function in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are different types of statements that are supported by sql?
What are the kinds of subquery?
What is extent? Types of extents?
What is a transaction and why is it important?
How to get the definition of a view out of the sql server?
What is data modification?
What are subquery and its properties?
What are the mathematical functions supported by sql server 2005?
If the job running very slow what is the action you do
Can we deploy SSRS reports on our personal website?
How to access the inserted record of an event?
Where are stored procedures in sql server?
What is the benefit of normalization?
