1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
with t
as
(
select 'Renault' as garage, 'Paris' as ville, 'Clio' as modele union all
select 'Renault' as garage, 'Paris' as ville, 'Megane' as modele union all
select 'Renault' as garage, 'Lyon' as ville, 'Clio' as modele union all
select 'Renault' as garage, 'Lyon' as ville, 'Megane' as modele union all
select 'Peugeot' as garage, 'Paris' as ville, '207' as modele union all
select 'Peugeot' as garage, 'Paris' as ville, '308' as modele union all
select 'Peugeot' as garage, 'Lyon' as ville, '207' as modele union all
select 'Peugeot' as garage, 'Lyon' as ville, '308' as modele
)
SELECT ville FROM t
except
SELECT ville
FROM t ville1
WHERE NOT EXISTS
(SELECT *
FROM t mod
WHERE NOT EXISTS
(SELECT *
FROM t ville2
WHERE ville1.ville = ville2.ville
AND (ville2.modele = mod.modele))) |
Partager