select col ,sumcol from biao , (select sum(col ) sumcol from (select t.col col from biao t) )
select col sumcol from table1,(select sum(col) sumcol from table1); 但是这样显示出来的结果是 col sum(col) a a+b+c b a+b+c c a+b+c 同时请教怎样才能实现 col sum(col) a a+b+c b c 这样的效果呢?
select col sumcol from table1 a left join (select sum(col) sumcol from table1) b on a.sumcol='a'; 不知对不对.
select col,sumcol from table1 a left join (select sum(col) sumcol from table1) b on a.col='a';
select distinct col,sumcol from table1 a left join (select sum(col) sumcol from table1) b on a.col='a';
(select sum(col ) sumcol from (select t.col col from biao t) )
但是这样显示出来的结果是
col sum(col)
a a+b+c
b a+b+c
c a+b+c
同时请教怎样才能实现
col sum(col)
a a+b+c
b
c
这样的效果呢?
不知对不对.