group by?

[Anonymous]

tableA:

load

id,

sum(sales) as  sales

from products

group by id;

here 

id   sales

1     100

2     200

3     300

4     400

what it gives output?

[CELAMBARASAN · Accepted solution]

Output will be same, No Change

Try with different input

id   sales

1     100

2     200

3     300

4     400

2     600

3     1000

will give you

id   sales

1     100

2     800       // 200+600

3     1300     //300+1000

4     400