mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
17 lines
403 B
SQL
17 lines
403 B
SQL
-- Origin SQL:
|
|
SELECT
|
|
*,
|
|
CASE
|
|
WHEN EXISTS(SELECT 1
|
|
FROM table_name
|
|
WHERE col1 = '999999999')
|
|
THEN 'then'
|
|
ELSE 'else'
|
|
END as check_result
|
|
FROM table_name
|
|
WHERE col1 = '123456789'
|
|
|
|
|
|
-- Format SQL:
|
|
SELECT *, CASE WHEN EXISTS(SELECT 1 FROM table_name WHERE col1 = '999999999') THEN 'then' ELSE 'else' END AS check_result FROM table_name WHERE col1 = '123456789';
|