SELECT LOCATION_ID,CITY
FROM HR.LOCATIONS
WHERE LOCATION_ID =10
UNION
SELECT LOCATION_ID ,CITY
FROM HR.LOCATIONS
WHERE CITY='Sao Paulo'
FROM HR.LOCATIONS
WHERE LOCATION_ID =10
UNION
SELECT LOCATION_ID ,CITY
FROM HR.LOCATIONS
WHERE CITY='Sao Paulo'
等效于
SELECT LOCATION_ID,CITY
FROM HR.LOCATIONS
WHERE LOCATION_ID =10
or CITY='Sao Paulo'
FROM HR.LOCATIONS
WHERE LOCATION_ID =10
or CITY='Sao Paulo'
-------------------------------------------------------------------------------------------------------
SELECT LOCATION_ID,CITY
FROM HR.LOCATIONS
WHERE LOCATION_ID =10 or LOCATION_ID=20 or LOCATION_ID=30
FROM HR.LOCATIONS
WHERE LOCATION_ID =10 or LOCATION_ID=20 or LOCATION_ID=30
等效于
SELECT LOCATION_ID,CITY
FROM HR.LOCATIONS
WHERE LOCATION_ID in (10,20,30)
FROM HR.LOCATIONS
WHERE LOCATION_ID in (10,20,30)
----------------------------------------------------------------------------------------------------
SELECT * FROM EMP where empno=7902 and DEPTNO IN (SELECT DEPTNO FROM DEPT WHERE JOB='ANALYST')
等效于
SELECT * FROM EMP b WHERE empno=7902 and exists (SELECT e.deptno FROM DEPT e WHERE e.DEPTNO=b.DEPTNO and
b.JOB='ANALYST')
b.JOB='ANALYST')
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8410760/viewspace-732004/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8410760/viewspace-732004/