wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27301 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
explain databases and sql server databases architecture? : Sql server database administration
What are joins in sql and what are the different types of joins?
Describe in brief sql server monitoring ways.
What are drillthrough reports?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Explain table valued parameters in sql server? Why tvp used?
What is the stuff?
What is difference between line feed ( ) and carriage return ( )?
What is the use of tempdb? What values does it hold?
What is the Disadvantage of indexed sequential file.
what is a correlated sub-query? : Sql server database administration
What are cursors stored procedures and triggers?
How many types of stored procedures are there in sql server?
Does sql server use t sql?
What methods do you follow to protect from sql injection attack?
