1.
select empno,ename,hiredata,
from emp
where hiredata between 1982-01-01 and 1985-12-31;
2.
select empno,ename,sal
from emp
where sal between 3000 and 5000;
3.
select empno,ename
from emp
where empno 10 or 20;
4.
select empno,ename
from emp
where job='SALESMAN',empno=7902 and 7566 and 7788;
5.
select empno,ename
from emp
where ename like 'W%';
6.
select empno,ename
from emp
where ename like '%T_';
7.
select empno,ename,comm
from emp
where comm is NULL;
8.
select empno,ename,job,sal,
from emp
where (sal > 2000) and (job = 'MANAGER' or job = 'SALESMAN');
9.
select empno,ename,job,sal,
from emp
where sal > 2000 and (job = 'MANAGER' or job = 'SALESMAN');
10.
select empno,ename,sal,deptno,
from emp
where (deptno = 10 or deptno = 20) and (sal between 3000 and 5000);
11.
select empno,ename,job,hiredata
from emp
where hiredata = 1981 and job is not like 'SALES%';
12.
select empno,ename,job,deptno,
from emp
where (job = 'SALESMAN' or JOB = 'MANAGER') and (deptno = 10 or deptno = 20) and ename like '%A%';
13.
select empno,ename,job,deptno,sal
from emp
where (deptno = 20 or deptno = 30)
order by sal ASC;
14.
select empno,ename,job,deptno,sal
from emp
where (sal between 2000 and 3000) and (daptno <> 10)
order by deptno SAC,sal DESC;
15.
select empno,ename,job,hiredata
from emp
where (hiredata between 1982 and 1983) and (job like 'SALES%' or job like 'MAN%')
order by hiredata DESC;
数据库练习
最新推荐文章于 2024-07-06 13:51:47 发布