336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
select
employee_id,last_name,job_id,salary
from
employees
where
salary < any (select salary from employees where job_id = 'IT_PROG')
and
job_id <> 'IT_PROG'< ANY : check maximum value
> ANY : check minimum value
= ANY : IN or "or"
> ALL : check the maximum value
< ALL : check the Minimum value
'Oracle' 카테고리의 다른 글
| Set Operator Sample. (0) | 2006.09.01 |
|---|---|
| Set Operator Sample. (0) | 2006.09.01 |
| Multiple operator.. (0) | 2006.09.01 |
| Guidelines for using subquery (0) | 2006.09.01 |
| Guidelines for using subquery (0) | 2006.09.01 |