oracle行专列，求总值

最新推荐文章于 2021-04-11 22:42:11 发布

SmallTenMr

最新推荐文章于 2021-04-11 22:42:11 发布

阅读量501

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/SmallTenMr/article/details/77991480

版权

数据库专栏收录该内容

17 篇文章 0 订阅

订阅专栏

create table scoreTable(name varchar2(20),score varchar2(20));

insert into scoreTable values('a','50');
insert into scoreTable values('a','60');
insert into scoreTable values('a','80');
insert into scoreTable values('b','90');
insert into scoreTable values('b','60');
insert into scoreTable values('b','50');
insert into scoreTable values('c','50');
insert into scoreTable values('c','100');
insert into scoreTable values('c','80');

select sum(decode(t.name,'a',t.score)) as a,
       sum(decode(t.name,'b',t.score))as b,
       sum(decode(t.name,'c',t.score))as c
from scoreTable t;