- /*
-
- SQL> SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS NAME,
- 2 E.COMMISSION_PCT,D.DEPARTMENT_NAME,L.CITY
- 3 FROM HR.EMPLOYEES E,HR.DEPARTMENTS D,HR.LOCATIONS L
- 4 WHERE E.DEPARTMENT_ID = D.DEPARTMENT_ID
- 5 AND D.LOCATION_ID = L.LOCATION_ID
- 6 AND E.COMMISSION_PCT IS NOT NULL;
|