select case when exists( select 1 from t_test c where c. name = 'zhangsan' and c.age = 23 ) then 1 else 0 endfrom dual;版权声明：本文为u011134399原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。
select case when exists( select 1 from t_test c where c. name = 'zhangsan' and c.age = 23 ) then 1 else 0 endfrom dual;