select max(sun) sun, max(mon) mon, max(tue) tue, max(wed) wed, max(thu) thu, max(fri) fri, max(sat) sat from (select decode(d, 1, dd) sun, decode(d, 2, dd) mon, decode(d, 3, dd) tue, decode(d, 4, dd) wed, decode(d, 5, dd) thu, decode(d, 6, dd) fri, d