Retrieve Values

• vani_r14

  SSCrazy

  Points: 2843

  More actions

  March 11, 2010 at 2:42 pm

  #216486

  [font="Verdana"]Hi all

  I am kind of stuck trying to find this out. Could some one please shed some light on this. I have a Table with the following structure please see attached

  I need to extract a table which checks and produces a result in one row for each staff member with the staffno, camins and cagrpmins. so the result should be in one row (please refer attached)

  I am kind of stuck doing this bit. any hints is greatly appreciated.

  Thanks

  Vani

  [/font]

• vani_r14

  SSCrazy

  Points: 2843

  More actions

  March 11, 2010 at 5:18 pm

  #1132395

  Hi all

  Its working now...

  if any one needs it below is the code

  select staffno, sum(camins), sum(cagrpmins) from Tablename groupby staffno

  cheers

  Vani