Rookie one, written examination encountered this problem, really do not know how to write, hope bosses give advice or comments, appreciated, and data table as follows, for the query result for below 2:

CodePudding user response:

Select * from t1
The pivot
(the sum of (amount) for the type in (' income ', 'spending')) mm

CodePudding user response:

Oracle oracle11.2, baidu row column,