SELECT * FROM ET_CHARGE_PILE_DATA_INFO where data_status='normal'
MINUS
SELECT * FROM ET_CHARGE_PILE_DATA_INFO where charge_pile_info_id in (
select id from ET_CHARGE_PILE_INFO where CHARGE_STATION_INFO_id in(
select id from ET_CHARGE_STATION_INFO where operator_id? in (
select id from ET_OPERATOR))) and data_status='normal'
前提是兩條SQL查詢出來的字段一模一樣,則可以用 “MINUS”連接相減堪澎,得出差集