Loading ...
Sorry, an error occurred while loading the content.

Group By command

Expand Messages
  • Justas
    Hello, I searched this group, but havent found any similar questions. For example, one has data like this: ID:1, Value:39; ID:15, Value:124; ID:1, Value:582;
    Message 1 of 1 , May 20, 2013
    • 0 Attachment
      Hello, I searched this group, but havent found any similar questions. For example, one has data like this:

      ID:1, Value:39;
      ID:15, Value:124;
      ID:1, Value:582;
      ....

      How to write a query to group the data by id and sum the values. In SQL it would be:

      SELECT id, SUM(Value) FROM data GROUP BY id

      Thank you in advance
    Your message has been successfully submitted and would be delivered to recipients shortly.