数据库的限定和排序数据.pptVIP

优先级规则 ENAME JOB SAL ---------- --------- --------- KING PRESIDENT 5000 MARTIN SALESMAN 1250 ALLEN SALESMAN 1600 TURNER SALESMAN 1500 WARD SALESMAN 1250 SQL SELECT ename, job, sal 2 FROM emp 3 WHERE job=SALESMAN 4 OR job=PRESIDENT 5 AND sal1500; 第30页，共36页。 优先级规则 ENAME JOB SAL ---------- --------- --------- KING PRESIDENT 5000 ALLEN SALESMAN 1600 使用扩号提高优先级（Very Imporatant） SQL SELECT ename, job, sal 2 FROM emp 3 WHERE (job=SALESMAN 4 OR