Geting negative and positive value

• Alen

  SSC Rookie

  Points: 28

  More actions

  March 11, 2004 at 5:13 am

  #107328

  HI!

   

  I want to get positive and negative sums of one product, how can i do that?

  My query:

  select goods,sum(quantity) table                                                       group by goods

  order by sum(quantity)

  so i want to get gruped and sumed goods but i want to get negative quantities sumed only with negative and positive with positive

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  March 11, 2004 at 5:42 am

  #498241

  SELECT Goods, SUM(Quantity) Both, SUM(CASE WHEN Quantity > 0 THEN Quantity END) Pos, SUM(CASE WHEN Quantity < 0 THEN Quantity END) Neg

  FROM Table

  GROUP BY Goods

  ORDER BY Goods, Both

  
  
  --Jonathan

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  March 11, 2004 at 5:53 am

  #498247

  Amazing what all can happen while typing. Fortunately I hit F5 before answering

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Alen

  SSC Rookie

  Points: 28

  More actions

  March 11, 2004 at 5:56 am

  #498249

  many thanks