SQL去重复语句或查询最后一次记录
产品表
| 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
