首頁猿問 SQL-'聚合查詢�...

SQL-'聚合查詢'-按10元為一個(gè)檔次，查詢單價(jià)各檔次的數(shù)量

SQL Server

阿晨1998 2018-12-07 01:06:20

select sum(a.a) '0-10',sum(a.b) '10-20',sum(a.c) '20-30',sum(a.d) '30以上'from (select case when price>0 and price<=10 then 1 end as a,case when price>10 and price<=20 then 1 end as b,case when price>20 and price<=30 then 1 end as c,case when price>30 then 1 end as dfrom titles) as a ? 這是我用? CASE when? 條件判斷。老師說雖然說結(jié)果對，但是這個(gè)寫著太復(fù)雜了，當(dāng)遇到1000條。是那我就要寫幾百幾千條CASE when 加以判斷，所以小弟在這求根據(jù)問題標(biāo)題的要求寫出結(jié)果一樣的，比較簡潔的語句，注意是聚合查詢。

查看完整描述

12 回答

素胚勾勒不出你

TA貢獻(xiàn)1827條經(jīng)驗(yàn) 獲得超9個(gè)贊

你好· 謝謝你大哥·~！這個(gè)語句不能在用這個(gè) 條件判斷寫了·~！

反對回復(fù) 2019-01-07

有只小跳蛙

TA貢獻(xiàn)1824條經(jīng)驗(yàn) 獲得超8個(gè)贊

你好；這個(gè)問題穿越自己的知識層面了·~再次謝謝你的關(guān)注·~！

反對回復(fù) 2019-01-07

蠱毒傳說

TA貢獻(xiàn)1895條經(jīng)驗(yàn) 獲得超3個(gè)贊

暫時(shí)還沒有想到很好的解決方案. 我寫的這個(gè)也不是太好,比較的復(fù)雜 select [a] as '0-10',[b] as '10-20',[c] as '20-30',[d] as '>30' from( select 'a' as flag,sum(price) as sumprice from title where price>0 and price<=10 union all select 'b' as b,sum(price) from title where price>10 and price<=20 union all select 'c' as b,sum(price) from title where price>20 and price<=30 union all select 'd' as b,sum(price) from title where price>30 ) PRICE pivot ( sum(sumprice) for flag in ([a],[b],[c],[d]) ) as PVT 還需要在尋求比較優(yōu)化的方法,謝謝!

反對回復(fù) 2019-01-07