Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM MyTable
- WHERE ID = (SELECT ID
- FROM MyTable
- WHERE ...whatever ...);
- WITH r AS (
- SELECT ID
- FROM MyTable
- WHERE ...whatever...
- )
- DELETE FROM MyTable
- WHERE (SELECT count(*) FROM r) = 1
- AND ID IN (SELECT ID FROM r)
- RETURNING ID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement