table: pivotedtable
amount |key1 |key2 |
==========================
10 |one |un |
12 |two |deux |
13 |one |deux |
14 |two |un |
create table pivotedtable (amount real, key1 varchar(5), key2 varchar(5));
insert into pivotedtable values (10,'one','un');
insert into pivotedtable values (12,'two','deux');
insert into pivotedtable values (13,'one','deux');
insert into pivotedtable values (12,'two','un');
insert into pivotedtable values (2, 'two','un');
\ key1|one |two |
\ | | |
key2\ | | |
======\===========
un |10 |14 |
deux |13 |12 |
Amount