問題描述如下我創(chuàng)建了一張?jiān)噲D,我想group by按照RD.SKU分組求和RD.QTYRECEIVED字段為sumsum,但是我想顯示select的六個(gè)字段,而不是就顯示RD.SKU和sumsum,說的簡(jiǎn)單點(diǎn)就是,sumsum字段想實(shí)現(xiàn)相同RD.SKU的RD.QTYRECEIVED和問題出現(xiàn)的環(huán)境背景及自己嘗試過哪些方法相關(guān)代碼// 請(qǐng)把代碼文本粘貼到下方(請(qǐng)勿用圖片代替代碼)CREATE OR REPLACE VIEW aaa ASSELECT R.WHSEID,
RD.STORERKEY,
RD.SKU,
RD.QTYRECEIVED,
RD.LOTTABLE04+8/24 AS LOTTABLE04,
sum(RD.QTYRECEIVED) as sumsumFROM ......省略關(guān)聯(lián)表group by R.WHSEID, RD.STORERKEY, RD.SKU, RD.QTYRECEIVED, RD.LOTTABLE04;你期待的結(jié)果是什么?實(shí)際看到的錯(cuò)誤信息又是什么?
添加回答
舉報(bào)
0/150
提交
取消