差分

==[[DB2 累積計を作成する]]==[[DB2]] | [[Database]{{category ] | [[Category:SQL}}]]

EMPNO FIRSTNME FI[[R]]STNME LASTNAME SALARY SALA[[R]]Y RUNNING_TOTAL[[R]]UNNING_TOTAL

200340 ROY [[R]]OY ALONZO 31840.00 31840.00 000290 JOHN PARKER PA[[R]]KE[[R]] 35340.00 67180.00

000310 MAUDE SETRIGHT SET[[R]]IGHT 35900.00 138450.00 200310 MICHELLE SPRINGER SP[[R]]INGE[[R]] 35900.00 174350.00 000280 ETHEL SCHNEIDER SCHNEIDE[[R]] 36250.00 210600.00 000270 MARIA MA[[R]]IA PEREZ PE[[R]]EZ 37380.00 247980.00

200240 ROBERT [[R]]OBE[[R]]T MONTEVERDE MONTEVE[[R]]DE 37760.00 323490.00 200120 GREG G[[R]]EG ORLANDO O[[R]]LANDO 39250.00 362740.00 000320 RAMLAL [[R]]AMLAL MEHTA 39950.00 402690.00 000230 JAMES JEFFERSON JEFFE[[R]]SON 42180.00 444870.00

000170 MASATOSHI YOSHIMURA YOSHIMU[[R]]A 44680.00 533390.00

200280 EILEEN SCHWARTZ SCHWA[[R]]TZ 46250.00 625010.00 200010 DIAN HEMMINGER HEMMINGE[[R]] 46500.00 671510.00

000240 SALVATORE SALVATO[[R]]E MARINO MA[[R]]INO 48760.00 767520.00 000250 DANIEL DAN[[IE]]L SMITH 49180.00 816700.00

000220 JENNIFER JENNIFE[[R]] LUTZ 49840.00 915790.00 000190 JAMES WALKER WALKE[[R]] 50450.00 966240.00 000180 MARILYN MA[[R]]ILYN SCOUTTEN 51340.00 1017580.00 000150 BRUCE B[[R]]UCE ADAMSON 55280.00 1072860.00 000200 DAVID BROWN B[[R]]OWN 57740.00 1130600.00

000140 HEATHER HEATHE[[R]] NICHOLLS 68420.00 1460720.00

200220 REBA [[R]]EBA JOHN 69840.00 1598980.00 000060 IRVING I[[R]]VING STERN STE[[R]]N 72250.00 1671230.00 000130 DELORES DELO[[R]]ES QUINTANA 73800.00 1745030.00 000050 JOHN GEYER GEYE[[R]] 80175.00 1825205.00 000100 THEODORE THEODO[[R]]E SPENSER SPENSE[[R]] 86150.00 1911355.00 000090 EILEEN HENDERSON HENDE[[R]]SON 89750.00 2001105.00

000010 CHRISTINE CH[[R]]ISTINE HAAS 152750.00 2442525.00