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
- 30324 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
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Do you know what are different types of replication in sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What triggers long term care?
what are the reporting service components in SSRS?
explain extended properties
What is usually the first word in a sql query?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What are diverse clauses that form a part of sql?
What is ddl and dml commands?
Explain trigger and trigger types?
What are partitioned views and distributed partitioned views?
What is cte (common table expression)?
How connect excel to sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
