select distinct col_productid from tbl_product where col_amount=(select max(sum(col_amount)) from tbl_product) group by col_productid 阿也是菜鸟,不知道这样对不对
select col_productid,max(数量) from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a
测试ok select * from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a where 数量=(select max(数量) from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a)02 700
测试ok select * from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a where 数量=(select max(数量) from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a)02 700这样测试OK
测试ok select col_productid,max(数量) from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a group by col_productid
上楼的建议不是和 select col_productid,数量 from (select col_productid,数量=sum(col_amount) from tbl_product group by col_productid)a一样的效果?
from tbl_product
where col_amount=(select max(col_amount) from tbl_product)
from tbl_product
where col_amount=(select max(col_amount) from tbl_product)
1 01 aaa 1 1 100.0
2 01 aaa 1 1 200.0
3 02 bbb 2 2 300.0
4 02 bbb 2 2 400.0
应该找出02,因为产品02的数量最多,是700
from tbl_product
where col_amount=(select max(sum(col_amount)) from tbl_product)
group by col_productid 阿也是菜鸟,不知道这样对不对
select col_productid,max(数量) from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a
select * from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a
where 数量=(select max(数量) from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a)02 700
select * from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a
where 数量=(select max(数量) from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a)02 700这样测试OK
select col_productid,max(数量) from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a
group by col_productid
select col_productid,数量 from
(select col_productid,数量=sum(col_amount) from tbl_product
group by col_productid)a一样的效果?