请问ORACLE怎么创建单表合计的视图

Question

SELECT ROW_NUMBER()OVER(ORDER BY RN) ID,NAME,NUM
FROM(
select MIN(ID) RN,NAME,sum(num) NUM 
from T
GROUP BY NAME)

Answer 1

非常感谢，我还有一个问题，如果是表后面再加一个REMARK，字符串类型，能让这个备注的内容也合并吗？

Answer 2

这REMARK的数据从哪来，否则就算加了这字段，视图也是不能更新的啊

Answer 3

select rownum id,t1.* from (select name,sum(num),to_char(wmsys.wm_concat(res)) from t group by name) t1 order by t1.name;

Answer 4

REMARK 只是作为备注，有些数据列有，有些没有，比如这样的表
ID           NAME                 NUM             REMARK
1                 AA                     5                        ABC
2                 AA                     6
3                BB                     8                         ASD
4                BB                     7                         EDF
5                CC                    9                          WER
6                CC                    9
合计后
ID             NAME                 NUM                     REMARK
1                  AA                     11                             ABC
2                  BB                    15                           ASD,EDF
3                 CC                    18                               WER
能不能实现这样的功能呢？

Answer 5

SELECT ROW_NUMBER()OVER(ORDER BY RN) ID,NAME,NUM,REMARK
FROM(
select MIN(ID) RN,NAME,sum(num) NUM,to_char(wmsys.wm_concat(REMARK)) REMARK
from T
GROUP BY NAME)