Oracle基础-group by 分组

--创表
create table T_NUM
(
  id     VARCHAR2(10) not null,
  name   VARCHAR2(10),
  sex    NVARCHAR2(10),
  age    NUMBER(10),
  tgroup VARCHAR2(10)
);
--插入数据
INSERT ALL
INTO T_NUM(ID,NAME,SEX,AGE,TGROUP) VALUES(1,'张三','男',20,1)
INTO T_NUM(ID,NAME,SEX,AGE,TGROUP) VALUES(2,'李四','男',21,1)
INTO T_NUM(ID,NAME,SEX,AGE,TGROUP) VALUES(3,'王五','男',24,2)
INTO T_NUM(ID,NAME,SEX,AGE,TGROUP) VALUES(4,'王二狗','男',30,3)
INTO T_NUM(ID,NAME,SEX,AGE,TGROUP) VALUES(5,'丽莎','女',20,4)
INTO T_NUM(ID,NAME,SEX,AGE,TGROUP) VALUES(6,'田鸡','男',32,4)
SELECT * FROM DUAL;
--提交
COMMIT;

--计算每组的平均年龄
SELECT A.TGROUP,AVG(AGE) FROM T_NUM A GROUP BY TGROUP;

注意：select 后面可以查到的字段只能是"被函数修饰后的字段"和"分组所依据的字段"。查询其他字段会报异常。