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