select pro_id,pro_name,pro_spec,pro_city,sum(psl_qty) '销售数量',
sum(psl_qty)*(psl_prc2-psl_prc1) '让利金额'
from pos.p_sale inner join pos.product on pro_id = psl_pro_id
where psl_br_id = '0104' and
psl_prc1 <> psl_prc2 and
psl_date between '2006/01/01' and '2007/01/10'
group by pro_id,pro_name,pro_spec,pro_city;
这段语句查询出来是重复的,请问哪儿有错误
会的请帮个忙,谢谢了
sum(psl_qty)*(psl_prc2-psl_prc1) '让利金额'
from pos.p_sale inner join pos.product on pro_id = psl_pro_id
where psl_br_id = '0104' and
psl_prc1 <> psl_prc2 and
psl_date between '2006/01/01' and '2007/01/10'
group by pro_id,pro_name,pro_spec,pro_city;
这段语句查询出来是重复的,请问哪儿有错误
会的请帮个忙,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货