add
remove
language
chart
show hidden
hide
db<>fiddle
Db2
DocumentDB
DuckDB
Firebird
MariaDB
MySQL
Oracle
Postgres
SQL Server
SQLite
TimescaleDB
YugabyteDB
11.1
11.5
12.1
0.114 (MongoDB 7.0)
0.116 (MongoDB 7.0)
1.4 LTS
3.0
4.0
5.0
10.2
10.3
10.4
10.5
10.6
10.7
10.8
10.9
10.11
11.4
11.8
12.3
5.5
5.6
5.7
8.0
8.4
9.7
11g Release 2
18c
21c
23c
23ai
26ai
8.4
9.3
9.4
9.5
9.6
10
11
12
13
14
15
16
17
18
19 beta 4
2012
2014
2016
2017 (Linux)
2017
2019 (Linux)
2019
2022
2025
3.8
3.16
3.27
3.39
3.45
3.53
2.11
2.14
2.28
2.6
2.8
2.18
2024.2 LTS
2025.2 LTS
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
Sakila
no sample DB
Sakila
no sample DB
Sakila
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
HR
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
db<>fiddle Statistics
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
AdventureWorks
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
no sample DB
run
abort
markdown
clear
donate
feedback
about
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
WITH yourTable AS ( SELECT 1000 AS Line_num, 6 AS Line_typ, 0 AS Cost FROM dual UNION ALL SELECT 2000, 7, 5000 FROM dual UNION ALL SELECT 3000, 7, 3000 FROM dual UNION ALL SELECT 4000, 7, 2000 FROM dual UNION ALL SELECT 5000, 6, 0 FROM dual UNION ALL SELECT 6000, 9, 3000 FROM dual UNION ALL SELECT 7000, 7, 2000 FROM dual UNION ALL SELECT 8000, 1, 2000 FROM dual ), cte AS ( SELECT t.*, CASE WHEN Line_typ IN (1, 6) THEN 1 ELSE 0 END AS flag FROM yourTable t ), cte2 AS ( SELECT t.*, SUM(flag) OVER (ORDER BY Line_num) AS grp FROM cte t ), cte3 AS ( SELECT t.*, MIN(Line_num) OVER (PARTITION BY grp) AS Min_Line_num FROM cte2 t ) SELECT MIN(Line_num) AS Line_num, MAX(CASE WHEN Line_num = Min_Line_num THEN Line_typ END) AS Line_typ, SUM(Cost) AS Cost FROM cte3 t GROUP BY grp ORDER BY MIN(t.Line_num);
LINE_NUM
LINE_TYP
COST
1000
6
10000
5000
6
5000
8000
1
2000