限制数据和对数据排序

Mysql

课后习题

image.png

sql

SELECT emp.ename,emp.hiredate,emp.job from emp
where emp.hiredate > ‘1982­7­9’ and emp.job <> ‘SALESMAN SELECT emp.ENAME FROM EMP where emp.ename LIKE ‘%A__’
SELECT emp.ename,emp.deptno from emp where emp.deptno not in (10,20) 
SELECT emp.ename FROM emp where mgr IS NULL
SELECT emp.ename,emp.sal,emp.deptno from emp where emp.sal >= 4500 and emp.deptno in (10,20)

image.png image.png
image.png
image.png