日期:2014-05-18 浏览次数:20419 次
select jym ,jyrq ,max(jysj) ,min(jyzh) ,max(jyje) ,max(sfh) ,sbbh ,min(sblsh) ,ptlsh,min(xydm) ,max(xynr) from #temp group by jym,jyrq,sbbh,ptlsh ------解决方案--------------------