By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
german | english |
---|---|
deutscher text | english text |
@sql |
---|
SELECT MAX(CASE WHEN language="german" THEN text END) AS "german",MAX(CASE WHEN language="english" THEN text END) AS "english" FROM mytable; |