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
- 29678 Views
- I also Faced
- E-Mail Answers
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 we can compare two database data?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What happens when the SQL Azure database reaches Max Size?
What is difference between count (*) and count 1?
What is a primary key?
How to create prepared statements using odbc_prepare()?
explain different types of joins? : Sql server database administration
How to implement service broker?
How to use linked server?
What is the use of for clause?
what are the critical issues you have resloved in your company
What is the difference between row_number and dense_rank?
What is difference between equi join and natural join?
What is the rdl file?
Can we use max in where clause?
