oracle分析函数 --SQL*PLUS环境<
/>--1、GROUP BY子句 <
/><
/>--CREATE TEST TABLE AND INSERT TEST DATA.<
/>create table students<
/>(id number(15,0),<
/>area varchar2(10),<
/>stu_type varchar2(2),<
/>score number(20,2));<
/><
/>insert into students values(1, 111, g, 80 );<
/>insert into students values(1, 111, j, 80 );<
/>insert into students values(1, 222, g, 89 );<
/>insert into students values(1, 222, g, 68 );<
/>insert into students values(2, 111, g, 80 );<
/>insert into students values(2, 111, j, 70 );<
/>insert into students values(2, 222, g, 60 );<
/>insert into students values(2, 222, j, 65 );<
/>insert into students values(3, 111, g, 75 );<
/>insert into students values(3, 111, j, 58 );<
/>insert into students values(3, 222, g, 58 );<
/>insert into students values(3, 222, j, 90 );<
/>insert into students values(4, 111, g, 89 );<
/>insert into students values(4, 111, j, 90 );<
/>insert into students values(4, 222, g, 90 );<
/>insert into students values(4, 222, j, 89 );<
/>commit;<
/><
/>col score format 999999999999.99<
/><
/>--A、GROUPING SETS <
/><
/>select id,area,stu_type,sum(score) score <
/>from students<
/>group by grouping sets((id,area,stu_type),(id,area),id)<
/>order by id,area,stu_type;
oracle分析函数
最新推荐文章于 2024-07-12 18:39:19 发布