wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
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?
What are the types of resultset?
Explain what are various ways to enhance the ssrs report?
What are the different types of sub-queries?
How do I know if localdb is running?
Explain multiserver query
Name some of the open source software that you can use in alternative to SSR?
How do I edit a procedure in sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What does it mean if @@cursor_row returns a negative number?
What is data compression? : sql server database administration
How to enter unicode character string literals in ms sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How would you choose between a clustered and a non-clustered index?
What is a virtual table in sql?