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
|
/* data sample */
with t as (
select 109455 no, 10 operation, 'RABOTEUSE' article, 2.3 temps from dual union all
select 109455, 20, 'RABOTEUSE', 5 from dual union all
select 109455, 30, 'RABOTEUSE', 4.7 from dual union all
select 109455, 40, 'RABOTEUSE', 9.1 from dual union all
select 109455, 50, 'RABOTEUSE', 0 from dual union all
select 109455, 60, 'RABOTEUSE', 9 from dual union all
select 300871, 30, 'PERCEUSE', 8.3 from dual union all
select 300871, 40, 'PERCEUSE', 5.9 from dual union all
select 300871, 50, 'PERCEUSE', 5.8 from dual
)
/* start of query */
select
no,
min(operation) operation,
min(article) keep (dense_rank first order by operation) article,
min(temps) keep (dense_rank first order by operation) temps
from t
group by no
;
NO OPERATION ARTICLE TEMPS
---------- ---------- --------- ----------
109455 10 RABOTEUSE 2.3
300871 30 PERCEUSE 8.3 |
Partager