Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 29219 Views
- I also Faced
- E-Mail Answers
Answer Posted / grace
SELECT TOP 3 * FROM <TABLE_NAME> WHERE <CONDITION> ORDER BY
<COLUMN_NAME> DESC
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is sql view?
Can we use where clause in union?
what does the automatic recovery do? : Sql server administration
What is table join?
What is a field in a table?
Explain having clause and where clause?
How to enforce security in sql server? : sql server security
What is Sqlpaging in SqlServer 2005 ?
How to set database to be read_only in ms sql server?
What is primary key, unique key, and foreign key?
What is the difference between dropping a database and taking a database offline?
Difference between primary key and clustered index?
Explain subquery and state its properties?
how to take backup bcp out for a column in table in sql server?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
