摘要:
1、如何查询重复的记录,并取出指定的记录? select * from Table1 t1 where id in (select max(id) from Table1 t2 where t1.id=t2.id)2、如何删除记录中重复的数据? delete from Table1 where id not in (selectid from Table1 t1 where id in (sele... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->select * into #Temp from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=c:\资... 阅读全文