Advertisement
Guest User

Untitled

a guest
Sep 17th, 2019
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.14 KB | None | 0 0
  1. SELECT id
  2. FROM tbl
  3. WHERE col1 IN ('00020', '00023')
  4. GROUP BY id
  5. HAVING GROUP_CONCAT(DISTINCT col1 ORDER BY col1) = '00020,00023';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement