pid相同 只取一条数据
select * from SP_WATER_FACILITY_LEDGER_PIPE tmp where pid in (41,42) and not exists(select 1 from SP_WATER_FACILITY_LEDGER_PIPE where pid=tmp.pid and create_time<tmp.create_time )
02-02
2956
pid相同 只取一条数据
select * from SP_WATER_FACILITY_LEDGER_PIPE tmp where pid in (41,42) and not exists(select 1 from SP_WATER_FACILITY_LEDGER_PIPE where pid=tmp.pid and create_time<tmp.create_time )