By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;
| BANNER |
|---|
| Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production |
| PL/SQL Release 11.2.0.2.0 - Production |
| CORE 11.2.0.2.0 Production |
| TNS for Linux: Version 11.2.0.2.0 - Production |
| NLSRTL Version 11.2.0.2.0 - Production |
WITH DRIVER( BUS_ID, DRIVER_NAME ) AS
(
SELECT 1,'John' FROM DUAL UNION ALL
SELECT 2,'John' FROM DUAL UNION ALL
SELECT 1,'Max' FROM DUAL UNION ALL
SELECT 2,'Max' FROM DUAL UNION ALL
SELECT 3,'Max' FROM DUAL UNION ALL
SELECT 4,'Max' FROM DUAL UNION ALL
SELECT 2,'Bill' FROM DUAL UNION ALL
SELECT 3,'Ron' FROM DUAL UNION ALL
SELECT 4,'Ron' FROM DUAL UNION ALL
SELECT 1,'Ron' FROM DUAL UNION ALL
SELECT 2,'Ron' FROM DUAL
), BUS( BUS_ID ) AS
(
SELECT 1 FROM DUAL UNION ALL
SELECT 2 FROM DUAL UNION ALL
SELECT 3 FROM DUAL UNION ALL
SELECT 4 FROM DUAL
)
SELECT D.DRIVER_NAME
FROM DRIVER D
GROUP BY D.DRIVER_NAME
HAVING COUNT(*) = (SELECT COUNT(*) FROM BUS)
| DRIVER_NAME |
|---|
| Ron |
| Max |