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 do you debug a procedure in sql server?
Explain use of expression builder.
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is a database in ms sql server?
What happens if the update subquery returns multiple rows in ms sql server?
How many levels of sp nesting is possible?
What are different types of join?
How efficient you are in oracle and SQL server?
What is the difference between a unique key and primary key?
How to use linked server?
how to trace the traffic hitting a sql server? : Sql server database administration
What are xml indexes?
What are the disadvantages of indexes?
What is sql server management studio? : sql server management studio
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration