产品表
pro_id pro_name pro_mem_id pro_ReissuedTime
112183 MR16灯杯 37570 2010-08-04 12:51:00
114490 LED恒流源(长寿命型) 37570 2010-08-04 12:51:00
45182 LED护拦管 15097 2010-08-04 12:39:00
45185 LED数码管 15097 2010-08-04 12:39:00
现在要掉pro_mem_id 重复的记录,且 pro_ReissuedTime 时间最新,当时间重复时取pro_id 最大的记录
select A.pro_id,A.pro_name,A.pro_mem_id,A.pro_ReissuedTime from [产品表] as A,(select max(pro_id) as Id,pro_mem_id,max(pro_ReissuedTime) as Date from [产品表] group by pro_mem_id) as B where A.pro_mem_id=B.pro_mem_id and A.pro_ReissuedTime=B.Date and A.pro_id=B.Id order by pro_ReissuedTime desc