How to replace the unpivot functions in the oracle, MySQL?

CodePudding user response:

No, on the SQL to find a way to, such as the pivot consider + case when using aggregate function, unpiovt consider using union all

CodePudding user response:

No can try a case when conversion

CodePudding user response:

MS SQL and Oracle support unpivot function, mysql does not support, egg is killing me,
I have a few lines, some of the data using a union all the code would be too long,