Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- AND count_sub>2 AND count_del<=2
- count_sub = 10
- count_del = 4
- count_sub = 4
- count_del = 1
- WHERE count_sub - count_del > 5
- SELECT a.id
- FROM tbl1 a
- INNER JOIN (SELECT id, count_sub - count_del AS diff FROM tbl1) b ON b.id = a.id
- WHERE b.diff > 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement