摘要: select identity(int,1,1) as autoID, * into #Tmp from [QYTS_QiYeCecdb]select min(autoID) as autoID into #Tmp2 from #Tmp group by wanfang_idselect * from #Tmp where autoID in(select autoID from #tmp2)select * into #Tmp3 from (select * from #Tmp where autoID in(select autoID from #tmp2)) as Tselect * f 阅读全文
posted @ 2014-02-15 14:38 孟小白 阅读(676) 评论(0) 推荐(0) 编辑