column sum

• denimblue

  Mr or Mrs. 500

  Points: 594

  More actions

  October 6, 2004 at 9:50 am

  #63443

  select filesize

  from o_file

  where volid = 2 and groupid = 200

  The rusult is multiple rows of filesize. What I need to no is:

  1. the sum of all the rows

  2. what it equals to in GB

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  October 6, 2004 at 10:02 am

  #525602

  select sum(filesize) as MB, sum(filesize)/1000 as GB
  from o_file
  where volid = 2 and groupid = 200

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!