How to put the above data into below, and ask for leave to pass the time find out all the number of days,
CodePudding user response:
A typical transfer line column, the test data and build table statements posted!CodePudding user response:
The select people_name people_unit,NVL (sum (case when QJLX='personal leave' then qj_num end), 0) as personal leave,
NVL (sum (case when QJLX='ask for leave to go out on business then qj_num end), 0) leave the as on business goes out,
- how many columns to add line
The sum (qj_num) as a combined
The from test6
Group by people_name people_unit;