SELECT a.subs_id,
a.phone ,a.new_phone FROM ( SELECT a.subs_id,
a.phone ,
CASE WHEN a.time<b.time THEN b.phone END new_phone
FROM CMPDATA_TB_SUBS_IMEI_CHAG_DTL a, CMPDATA_TB_SUBS_IMEI_CHAG_DTL b
WHERE a.subs_id=b.subs_id )a WHERE a.new_imei>0;
这是我写的多了A-C的记录