EasyDemo*表查询-逻辑&&别名&&数据分组&&group by、having子句

一、逻辑&&order by&&别名排序

select * from emp where (sal>500 or job ='MANAGER') and ename like 'J%';
select * from emp order by sal;
select * from emp order by sal asc;
select * from emp order by sal desc;
select * from emp order by deptno,sal desc;

二、数据分组-max,min,avg,sum,count

select max(sal),min(sal) from emp;
select ename,sal from emp where sal=(select max(sal) from emp);
select avg(sal) from emp;
select * from emp where sal>(select avg(sal) from emp);

三、group by和having子句

select avg(sal),max(sal),deptno from emp group by deptno;
select avg(sal),max(sal),deptno from emp group by deptno having avg(sal)>2000;