wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
Answer Posted / krishna sandeep
select top 3 <column_name> from ,table_name> order by
<column_name> desc
this will work.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of forms?
How do I determine how many instances of sql server are installed on a computer?
Explain system scalar functions?
How do I start sql server agent automatically?
What is difference between line feed ( ) and carriage return ( )?
What happens when converting big values to integers?
What is sql server transaction log file?
How do I manually uninstall an instance of sql server 2016?
Define self join?
How to delete an existing row with delete statements in ms sql server?
What are the mathematical functions supported by sql server 2005?
What is difference between global temporary tables and local temporary tables?
What the difference between UNION and UNIONALL?
Can I save my report as html, excel or word? : sql server management studio
What command is used to delete a table from the database in the sql server and how?