clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
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. 1228823 fiddles created (16673 in the last week).

select version();
version
PostgreSQL 9.6.15 on x86_64-pc-linux-gnu (Debian 9.6.15-1.pgdg80+1), compiled by gcc (Debian 4.9.2-10+deb8u2) 4.9.2, 64-bit
 hidden batch(es)


CREATE TABLE PivotTable (BerthId int, ShipType text, ShipSize text); --Populate Sample records INSERT INTO PivotTable VALUES(1,'Tanker','RoRo'); INSERT INTO PivotTable VALUES(1,'Tanker','small tanker'); INSERT INTO PivotTable VALUES(1,'Main Cargo', 'Small Main Cargo'); INSERT INTO PivotTable VALUES(2, 'Tanker', 'Small Tanker');
1 rows affected
1 rows affected
1 rows affected
1 rows affected
 hidden batch(es)