oracle 视图求和问题

[kong_d_f]

某表中有int字段money，求在一条sql中可以查询出所有money和sum(money)

id money
1 10.00
2 15.00
3 15.00

希望查询出来的结果是
id money sum
1 10.00 40.00
2 15.00 40.00
3 15.00 40.00

我使用
select id,money,sum(money) over()
from table
语句可以查询出想得到的结果，可将语句加到创建的视图内后，sum得到的结果是全表的money和，并没有收到ｗｈｅｒｅ　ｉｄ　＝　？的限制，请问该如何解决？

[kong_d_f]

[Quote=引用 1 楼 hdhai9451 的回复:]
create or replace view vie_name
as
select id,money,(select sum(money) from table) sum
from table
[/Quote]
子查询内没有限制条件，查询出来的依然是全表的和

[rexyudl]

create or replace view vie_name 
as 
select id,money,sum(money)  from table 

[cataclyam2000]

select id,money,sum(money) as summoney over()
from (select id,money from table where id=?)

[kong_d_f]

[Quote=引用 3 楼 rexyudl 的回复:]
SQL code
create or replace view vie_name
as
select id,money,sum(money) from table
[/Quote]
未分组函数

[yjdfff]

SELECT ID,MONEY,(SELECT SUM(MONEY) FROM T) SUM1
FROM T

[Andy__Huang]

create or replace view vie_name
as
select id,money,(select sum(money) from table) sum
from table

[maqinqin]

[Quote=引用 3 楼 rexyudl 的回复:]
SQL code
create or replace view vie_name
as
select id,money,sum(money) from table
[/Quote]

create or replace view vie_name
as
select id,money,sum(money) over() from table

[多壮志]

[Quote=引用 1 楼 hdhai9451 的回复:]
create or replace view vie_name
as
select id,money,(select sum(money) from table) sum
from table

[/Quote]

这个直观。不过既然啊是比较明确的sum,没有必要用over，除非是每个都不通,
否则直接

create or replace view vie_name
  as 
    select a.id,a.money,b.ttl_money  from  table a ,
           (select nvl(sum(money),0) ttl_money from table ) b ;

我想会更快一些。

[pobaby]

create or replace view vie_name 
as 
select id,money,sum(money)  from table  group by id,money

[libolibo888]

create or replace view vie_name
as
select id,money,(select sum(money) from table where id=?) sum
from table

经过测试是通过的。