Home > database >  Urgent for DB2 dynamic transfer line column (online, etc.)
Urgent for DB2 dynamic transfer line column (online, etc.)

Time:11-07

The database version of DB2 9.5

The original data table structure as follows

Cstname planid ctime kpiname kplval
Zhang SAN P21 contract number 2019-2-12 4
Zhang SAN P21 customer number 20 2019-2-12
Zhang SAN P21 100 total amount 2019-2-12
Li si P45 customer number 32 2019-2-12
Li si P45 the 2019-2-12 attendance 90%


Page display need table structure
Cstname planid ctime contract number customers total sum attendance
Zhang SAN P21 4 20, 100-2019-2-12
Li si P45 2019-2-12-32-90%


The business scenario is zhang SAN and li si respective kipname how many uncertain data




  •  Tags:  
  • DB2