mysql里面也没法执行，有什么参数配置吗？

这个sql返回的就是满足条件的，fired本来就等于1了不会有0的数据，你再加个where fired = 1 没有必要把，这是我的数据和结果


达梦里面可以用使用伪表绕一下

with s as 
     (select CASE WHEN COUNT(1) > 0 THEN 1 ELSE 0 END as "FIRED", 
              DIAL_TEST_TASK_API_ID 
         FROM ALARM_STRATEGY_STATUS
        WHERE del_flag = 0 
     GROUP BY DIAL_TEST_TASK_API_ID
     )
select * from s where FIRED ='1'

select count(1) fired,dial_test_task_api_id from alarm_strategy_status s
where s.del_flag = 0
group by dial_test_task_api_id
having fired =1
这样试试呢