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
How to count groups returned with the group by clause in ms sql server?
explain how to create a new schema in a database? : Sql server database administration
Explain how many types of relationship?
Which tcl commands are available on the sql server?
What is for xml in sql server?
How can you insert values in multiple rows using one Insert statement?
What is de-normalization and what are some of the examples of it?
How many categories of functions based their return modes?
What is the data type of time?
What is the New in SQL server 2008?
Explain the disadvantages of cursors?
Explain the purpose of indexes?
How to optimize stored procedure optimization?
what are the different stages of Report Processing?
What is the meaning of resultset type_scroll_insensitive?