原sql语句
SELECT
a.a1,
a.a2,
case WHEN exists(SELECT b1 FROM b WHERE b1 =100) then 0 ELSE 1 END AS b2
FROM a
在格式化后
SELECT a.a1,
--------- a.a2,
---------CASE WHEN exists(
SELECT b1
FROM b
WHERE b1 = 100) THEN 0 ELSE 1 END AS b2
FROM a
可否优化exists后括号内子查询的缩进,如
SELECT a.a1,
---------a.a2,
---------CASE WHEN exists
---------(
------------SELECT b1
------------FROM b
------------WHERE b1 = 100
---------) THEN 0 ELSE 1 END AS b2
FROM a
原sql语句
SELECT
a.a1,
a.a2,
case WHEN exists(SELECT b1 FROM b WHERE b1 =100) then 0 ELSE 1 END AS b2
FROM a
在格式化后
SELECT a.a1,
--------- a.a2,
---------CASE WHEN exists(
SELECT b1
FROM b
WHERE b1 = 100) THEN 0 ELSE 1 END AS b2
FROM a
可否优化exists后括号内子查询的缩进,如
SELECT a.a1,
---------a.a2,
---------CASE WHEN exists
---------(
------------SELECT b1
------------FROM b
------------WHERE b1 = 100
---------) THEN 0 ELSE 1 END AS b2
FROM a