wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 25604 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
Explain the first normal form(1nf)?
Does sql server use java?
What does Master database contains?
What are different types of database indexes?
Explain primary key and foreign key constraints?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the difference between for trigger and after trigger?
What the difference between UNION and UNIONALL?
How to create a simple stored procedure in ms sql server?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to modify the underlying query of an existing view?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What does it mean to invest in the index?
What are the different types of indexes?
What is the difference between osql and query analyzer?
