27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT productname,SUM(unitprice), dengji FROM (
select productname,unitprice, dengji=
case
when unitprice <10 THEN 'A级'
when unitprice>=10 and unitprice <20 THEN 'B级'
when unitprice>=20 and unitprice <30 THEN 'C级'
when unitprice>=30 and unitprice <40 THEN 'D级'
when unitprice>=40 THEN 'D级'
end
from Products)T GROUP BY productname, dengji
Select * ----你要的結果
from
(select productname,unitprice,
(case
when unitprice <10 THEN 'A级'
when unitprice>=10 and unitprice <20 THEN 'A级'
when unitprice>=20 and unitprice <30 THEN 'B级'
when unitprice>=30 and unitprice <40 THEN 'C级'
when unitprice>=40 THEN 'D级'
end ) as dengji
from Products ) a
group by a.dengji