selset ename,job,dname from scott.emp,scott.dept where sal between 3000 and 5000 and emp.deptno=dept.deptno;（检索SCOTT.EMP和DEPT表中工资在3000-5000之间的雇员的姓名、职位和所在部门，关联列为DEPTNO）
●IN：
selset ename,job,dname from scott.emp,scott.dept where sal between 3000 and 5000 and emp.deptno=dept.deptno;
select column_name_1,...,column_name_n from table_name_1,...,table_name_n where column_name IN(value_1,value_2,...,value_n);
select column_name_1,...,column_name_n from table_name_1,...,table_name_n where column_name=value_1 or column_name=value_2 or ... or column_name_n;
4、ORDER BY子句
（1）ORDER BY子句语法：
SELECT column_name_1,...,column_name_n
FROM table_name_1,...,table_name_n
ORDER BY column_name_1,...,column_name_n ASC|DESC;
