Db2 Developer-C 11.1
Firebird 3.0
MariaDB 10.2 (unavailable)
MariaDB 10.3
MariaDB 10.4
MariaDB 10.5
MySQL 5.5
MySQL 5.6
MySQL 5.7
MySQL 8.0
Oracle 11g Release 2
Oracle 18c
Postgres 8.4 (unavailable)
Postgres 9.4 (unavailable)
Postgres 9.5
Postgres 9.6
Postgres 10
Postgres 11
Postgres 12
Postgres 13
SQLite 3.8 (unavailable)
SQLite 3.16 (unavailable)
SQLite 3.27
SQL Server 2012 (unavailable)
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2017 (Linux)
SQL Server 2019
SQL Server 2019 (Linux)
No sample DB
run
clear
markdown
compare
help
best fiddles
feedback
dbanow.uk
a leap of faith?
Fiddle Statistics
MySQL 8.0
SQLite 3.27
Oracle 18c
Firebird 3.0
MariaDB 10.4
MySQL 5.7
MySQL 5.6
MySQL 5.5
MariaDB 10.3
Db2 Developer-C 11.1
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2017 (Linux)
SQL Server 2019 (Linux)
SQL Server 2019
Postgres 12
Postgres 9.5
Postgres 11
Postgres 10
Postgres 9.6
MariaDB 10.5
Oracle 11g Release 2
Postgres 13
≡
clear
markdown
donate
comments/suggestions/bugs
a leap of faith?
bible365
diddy dollings
By using db<>fiddle, you agree to license everything you submit by
Creative Commons CC0
.
1579701 fiddles created (21404 in the last week).
CREATE TABLE tbl (customerID varchar(10), status int); INSERT INTO tbl VALUES ('XXX', 1), ('XXX', 2), ('XXX', 3), ('YYY', 2), ('YYY', 2), ('XXX', 1), ('XXX', 4), ('YYY', 4);
8 rows affected
hidden batch(es)
SELECT customerID, [1], [2], [3], [4] FROM ( SELECT customerID, status FROM tbl ) src PIVOT ( COUNT(status) FOR status IN ([1], [2], [3], [4]) ) pvt;
customerID
1
2
3
4
XXX
2
1
1
1
YYY
0
2
0
1
…
hidden batch(es)