oracle的聚集函数

//聚集函数
max,min,avg,count,sum

select count(*) from dept;
select count(deptno) from dept;

//user,decode,nvl
select user from dual;
select sum(decode(a1,'abc',1,0)),sum(decode(a1,'bca',1,0)) from aa;
select a1,nvl(a2,'NULL') from aa;
select * from aa where a2 is null;
select * from aa where a2 is not null;
select * from aa order by a1 asc;
select * from aa order by a1 asc;
//查询不重复的
select distinct a1 from aa;

分组查询
select id,sum(price) from aa group by id;