Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CASE
- WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state1} == :data1)
- THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state1} == :data1))
- WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state2} == :data2)
- THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state2} == :data2))
- WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state3} == :data3)
- THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state3} == :data3))
- WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state3} == :data3)
- THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state3} == :data3))
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement