GROUP BY + an aggregate function SELECT customer_id, SUM(amount) FROM table GROUP BY customer_id will group up all repeating rows into one and sum their amounts into one — select the customer_id and take the sum of the amount column from the table grouped by the customer_id some SQL engines need you to select the column you are grouping by

Your Commento.io account has been suspended. Go to the Commento dashboard to resolve this.
Get

Explore more quotes

Momchil Kolev