【SQL语句条件查询WHERE关键字的使用】
select * from emp
select * from dept;
select deptno,dname from dept
select * from salgrade
select * from bonus
//SQL条件查询,查询部门编号小于30的
select * from dept where deptno < 30
//查询部门编号小于30,并且只查询depno和dname两列
select deptno,dname from dept where deptno < 30
//查询LOC工作地点在纽约工作的部门名称
select dname from dept where loc = ‘NEW YORK’
SELECT DNAME FROM DEPT WHERE LOC =‘new york’