Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. DELETE FROM MyTable
  2. WHERE ID = (SELECT ID
  3. FROM MyTable
  4. WHERE ...whatever ...);
  5.  
  6. WITH r AS (
  7. SELECT ID
  8. FROM MyTable
  9. WHERE ...whatever...
  10. )
  11. DELETE FROM MyTable
  12. WHERE (SELECT count(*) FROM r) = 1
  13. AND ID IN (SELECT ID FROM r)
  14. RETURNING ID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement