select * from jd_t_sb_wxtz$dc$jxjl a, (select max(vc_date) maxtime,vc_pid from jd_t_sb_wxtz$dc$jxjl group by vc_pid ) b where a.vc_date=b.maxtime and a.vc_pid=a.vc_pid
select * from jd_t_sb_wxtz$dc$jxjl a, (select max(vc_date) maxtime,vc_pid from jd_t_sb_wxtz$dc$jxjl group by vc_pid ) bwhere a.vc_date=b.maxtime and a.vc_pid=a.vc_pid