As shown in figure a temporary table, behind the serial number how column data, only a list of all the columns have the time, how to incorporate the columns of have time to a list of

CodePudding user response:

The pivot column turned luo

Select * from tableName
The pivot (Max (val) for col (in processing time 2, processing time is 3,... )) p

CodePudding user response:

Just solved the ha ha, it is column turned instantly