How to SUM two columns RSS

• • Reply
  

  aparitala

  Member

  14 Points

  91 Posts

  How to SUM two columns

  Dec 03, 2012 03:58 PM|LINK

  How to SUM WOrked and show these two as 1 column

  ID             Worked
  1587              8
  1587             3

  Like

  ID             Worked
  1587              11

• • Reply
  

  imapsp

  Member

  134 Points

  22 Posts

  Re: How to SUM two columns

  Dec 03, 2012 04:02 PM|LINK

  Try:

  select ID, sum(Worked) as Worked
  from MyTable
  group by ID

  Hope this helps. 

  www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento
  • Edited by imapsp on Dec 03, 2012 04:02 PM
  • Marked as answer by aparitala on Dec 03, 2012 04:02 PM
• • Reply
  

  aparitala

  Member

  14 Points

  91 Posts

  Re: How to SUM two columns

  Dec 03, 2012 04:02 PM|LINK

  I got it thank you...!