Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.cust_id, c.cust_type_cd, c.city, count(*) as `count`
- FROM customer c
- INNER JOIN account a
- ON a.cust_id = c.cust_id
- GROUP BY c.cust_id
- HAVING `count` = 2;
- +---------+--------------+---------+-------+
- | cust_id | cust_type_cd | city | count |
- +---------+--------------+---------+-------+
- | 2 | I | Woburn | 2 |
- | 3 | I | Quincy | 2 |
- | 6 | I | Waltham | 2 |
- | 8 | I | Salem | 2 |
- | 10 | B | Salem | 2 |
- +---------+--------------+---------+-------+
- SELECT c.cust_id, c.cust_type_cd, c.city
- FROM customer c
- WHERE 2 = (
- SELECT COUNT(*)
- FROM account a
- WHERE a.cust_id = c.cust_id
- );
- +---------+--------------+---------+
- | cust_id | cust_type_cd | city |
- +---------+--------------+---------+
- | 2 | I | Woburn |
- | 3 | I | Quincy |
- | 6 | I | Waltham |
- | 8 | I | Salem |
- | 10 | B | Salem |
- +---------+--------------+---------+
Add Comment
Please, Sign In to add comment