星期三—简单的练习数据库的使用

1、select * from EMP where deptno = 30;

2、select * from EMP where job = 'MANAGER';

3、select * from EMP where COMM>sal;

4、select * from EMP where (deptno =10 and job ='MANAGER')

or (deptno = 20 and job = 'CLERK');

 

5、select * from EMP where deptno = 10 and job not in ('MANAGER','clerk')and sal>=2000;

 

 

6、select * from EMP where comm is not null and comm>0;

7、select * from EMP where comm<500 or comm is null;

8、select ename from EMP order by hiredate;

9、select * from EMP t;

 

转载于:https://www.cnblogs.com/wx1691790309/p/7157273.html