Files
sqlparser/parser/testdata/query/select_case_when_exists.sql

12 lines
207 B
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'