sql 查询，来人看看，这块不熟

我想一条sql查询出来的结果变成

 select off_pro_id, pro_name, spec, unit_price, sum(pr_num) 
from table_name group by off_pro_id, pro_name, spec, unit_price

select off_pro_id,pro_name,spec,unite_price,pr_num,num,sum(select pr_num from tablename where .... ) from tablename,tablename为表名，不知道你具体的表是什么样子，还有些什么数据，关联这些，也可以用case when来实现

select off_pro_id,pro_name,spec,unit_price,sum(pr_num) from 表名 group by off_pro_id,pro_name,spec,unit_price；

你想要的最后结果是什么样的？

select off_pro_id, sum(pr_num) from table group by off_pro_id

结果头两列是什么结果？

select off_pro_id,pro_name,spec,unite_price,pr_num,num,sum(select pr_num ) from tablename group by off_pro_id

select off_pro_id,pro_name,spec,unite_price,pr_num,num,sum(select pr_num ) from tablename group by off_pro_id