select ID ,sum(QUANTITY) from tb group by ID having(ID)>1
select id,sum(QUANTITY ) as QUANTITY from table group by id
select id,sum(QUANTITY ) QUANTITY from table group by id
select ID ,sum(QUANTITY) from tb group by ID having count(ID)>1 select id,sum(QUANTITY ) QUANTITY from table group by id 但我有这两个语句查询的结果不一样,有谁帮我看看什么区别吗, select ID ,sum(QUANTITY) from tb group by ID having count(ID)>1 我查询只有103行,而 select id,sum(QUANTITY ) QUANTITY from table group by id查出有163行,不知道有什么区别
select ID ,sum(QUANTITY) from tb group by ID having count(ID)>1 分組後只對有重複的進行相加 如a 5 a 12 b 20 b 15 b 3 c 5 c 6 d 10 中d就不會參加運算 去掉 having count(ID)>1 所有的都在分組後參加運算
select id,sum(QUANTITY ) QUANTITY from table group by id
但我有这两个语句查询的结果不一样,有谁帮我看看什么区别吗,
select ID ,sum(QUANTITY) from tb group by ID having count(ID)>1 我查询只有103行,而
select id,sum(QUANTITY ) QUANTITY from table group by id查出有163行,不知道有什么区别
分組後只對有重複的進行相加
如a 5
a 12
b 20
b 15
b 3
c 5
c 6
d 10 中d就不會參加運算
去掉 having count(ID)>1 所有的都在分組後參加運算