圖中的JCRQ是2019-08-01------2019-08-31，我想得到這個月內每隔7天進行一次sum(JLJE)的計算結果，最后大概的值類似于這樣：
800 500 400 200 100
哪位大神會處理，請大神給出個例子供小弟學習研究研究，謝謝，求大神多多指點。
uj5u.com熱心網友回復：
group by trunc(to_char(JCRQ,'dd')/7)uj5u.com熱心網友回復：
不太明白你說的每隔七天聚合一次什么意思啊uj5u.com熱心網友回復：
SELECT SUM(JLJE),CASE
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '01' AND '07' THEN 1
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '08' AND '14' THEN 2
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '15' AND '21' THEN 3
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '22' AND '28' THEN 4
ELSE 5
END
FROM TABLE_NAME JCRQ
GROUP BY
CASE
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '01' AND '07' THEN 1
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '08' AND '14' THEN 2
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '15' AND '21' THEN 3
WHEN TO_CHAR(SYSDATE,'DD') BETWEEN '22' AND '28' THEN 4
ELSE 5
END ;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/29770.html
標籤：高級技術
下一篇：如何計算統計值 的百分比呢？