sql结果集相减

最新回答

我帆布比你高跟还青春

2026-10-24 18:05:22

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”连接相减，得出差集

我要回答

匿名回答

sql结果集相减

您可能感兴趣问答

Collapsible

热门标签

热点问答