Oracle are multiple numerical number, how do you write statement?
Table: name, job content, work 1, 2, 3 work, work 4, 5, 6), start time and end time, note, query workload, by the month to display image style, according to the

CodePudding user response:

Since this is a monthly, how no month column?
The wisdom of the reference questions - given script, the test data, the desired results, etc

CodePudding user response:

A typical transfer line column and summary

CodePudding user response:

refer to the second floor stelf response:

a typical transfer line column plus summary

query by the month, is the meaning of statistics every month once a month, list the beginning of the end time is to work every day will be recorded in the system, (such as work 1 begin and end the)

CodePudding user response:

SELECT *
The FROM (select T.E NAME, T.J OB, T.S AL FROM emp t)
The pivot (sum (sal)
For the job in (' CLERK ', 'SALESMAN', 'MANAGER', 'ANALYST'));

But this statement running effect

CodePudding user response:

Get some data out then the effect of the want to say it

CodePudding user response:

Difficult data also not