Using Max and Decode functions to convert columns into line __ functions

Directly query the SQL statement, the "element_name" element into the row display.

SELECT v.element_name,v.result_value from Pay_run_results_v V WHERE v.assignment_action_id=64293

Conversion of SQL statements, skillfully using Max and decode

SELECT MAX (DECODE (element_name, ' cdgm_ performance pay ', Result_value, 0)) performance pay,

MAX (DECODE (element_name, ' taxation information ', Result_value, 0)) Taxationinformation,

MAX (DECODE (element_name, ' Taxation deduction ', Result_value, 0)) Taxationdeduction,

MAX (DECODE (element_name, ' Tax, Information ', Result_value, 0)) Taxreportinformation,

MAX (DECODE (element_name, ' cdgm_ should be total ', Result_value, 0)) should be issued in total,

MAX (DECODE (element_name, ' cdgm_ ", Result_value, 0)) is invalid,

MAX (DECODE (element_name, ' cdgm_ total ", Result_value, 0)) Total

From Pay_run_results_v

WHERE assignment_action_id=64293