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 26 27 28
|
with data(Colonne_creation, Numero_de_serie) as (
select 'Création', 'DA2347652050' union all
select 'Machine Réparée', 'DA2347652050' union all
select 'En Attente', 'DA2347652050' union all
select 'Création', 'DA2347652287' union all
select 'Machine Réparée', 'DA2347652287' union all
select 'En Attente', 'DA2347652287' union all
select 'Création', 'DA2344655250' union all
select 'En Attente', 'DA2344655250' union all
select 'Création', 'DA2345653179' union all
select 'En Attente', 'DA2345653179' union all
select 'Création', 'DA2346652218' union all
select 'Machine Réparée', 'DA2346652218' union all
select 'En Attente', 'DA2346652218' union all
select 'Création', 'DA2344655250' union all
select 'Machine Réparée', 'DA2344655250' union all
select 'En Attente', 'DA2344655250' union all
select 'Création', 'DA2344655999'
)
select Numero_de_serie
from data
group by Numero_de_serie having (
(count(case Colonne_creation when 'Machine Réparée' then 1 end) < count(case Colonne_creation when 'En Attente' then 1 end))
and count(case Colonne_creation when 'En Attente' then 1 end) <> 0
)
; |
Partager