Guest User

Untitled

a guest
Feb 19th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. SELECT c.cust_id, c.cust_type_cd, c.city, count(*) as `count`
  2. FROM customer c
  3. INNER JOIN account a
  4. ON a.cust_id = c.cust_id
  5. GROUP BY c.cust_id
  6. HAVING `count` = 2;
  7.  
  8. +---------+--------------+---------+-------+
  9. | cust_id | cust_type_cd | city | count |
  10. +---------+--------------+---------+-------+
  11. | 2 | I | Woburn | 2 |
  12. | 3 | I | Quincy | 2 |
  13. | 6 | I | Waltham | 2 |
  14. | 8 | I | Salem | 2 |
  15. | 10 | B | Salem | 2 |
  16. +---------+--------------+---------+-------+
  17.  
  18. SELECT c.cust_id, c.cust_type_cd, c.city
  19. FROM customer c
  20. WHERE 2 = (
  21. SELECT COUNT(*)
  22. FROM account a
  23. WHERE a.cust_id = c.cust_id
  24. );
  25.  
  26. +---------+--------------+---------+
  27. | cust_id | cust_type_cd | city |
  28. +---------+--------------+---------+
  29. | 2 | I | Woburn |
  30. | 3 | I | Quincy |
  31. | 6 | I | Waltham |
  32. | 8 | I | Salem |
  33. | 10 | B | Salem |
  34. +---------+--------------+---------+
Add Comment
Please, Sign In to add comment