两者都能看到 NSA01_DELAY 的count 条数 select uc_txn_id,scenario_status,count(1) cnt from opgcep2.gcal_execution_task where created_at > systimestamp - 2/24 group by scenario_status,uc_txn_id having uc_txn_id is null and scenario_status = 'NSA01_DELAY'; select count(1) cnt from opgcep2.gcal_execution_task where created_at > systimestamp - 2/24 and uc_txn_id is null and scenario_status = 'NSA01_DELAY' 原文链接：https://www.f2er.com/oracle/213611.html