How to add values from a column and show the total result into another column?

• DiabloSlayer

  SSCrazy

  Points: 2232

  More actions

  June 25, 2008 at 1:16 pm

  #188425

  Hello Everyone,

  I have a table 'employee' with 3 columns, EMPNO, HRS_WRKD, PAYCODE_NAME

  I run the following query to get totals on worked paycode

  select EMPNO, sum(HRS_WRKD), PAYCODE_NAME

  I get the following result

  EMPNO HRS_WRKD PAYCODE_NAME

  1234 32

• RubyRed

  Mr or Mrs. 500

  Points: 509

  More actions

  June 25, 2008 at 1:20 pm

  #834237

  select EMPNO, sum(HRS_WRKD), PAYCODE_NAME

  from tablename

  group by EMPNO, PAYCODE_NAME