Advertisement
Guest User

Untitled

a guest
Nov 15th, 2019
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. SELECT CASE
  2. WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state1} == :data1)
  3.     THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state1} == :data1))
  4. WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state2} == :data2)
  5.     THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state2} == :data2))
  6. WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state3} == :data3)
  7.     THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state3} == :data3))
  8. WHEN EXIST(SELECT 1 FROM ${TABLE_NAME} WHERE ${state3} == :data3)
  9.     THEN(SELECT * FROM ${TABLE_NAME} WHERE ${state3} == :data3))
  10. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement