wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 27424 Views
- I also Faced
- E-Mail Answers
Answer Posted / arun kumar k s
drop table #temp select identity(int,1,1) as SlNo, * into
#temp from TABLE_NAME select top 3 * from #temp order by
SlNo desc
arun_4454@yahoo.co.in
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Why it is recommended to avoid referencing a floating point column in the where clause?
How to create hyperlink from returned sql query ?
What do you understand by the denormalisation?
What is the difference between the 2 operating modes of database mirroring?
How sql server enhances scalability of the database system?
what is denormalization and when would you go for it? : Sql server database administration
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is rs.exe utility?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How do I view a trc file?
How to retrieve error messages using mssql_get_last_message()?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is dbcc updateusage?
Explain what is use of dbcc commands?
