NON-EQUI JOIN

NON-EQUI JOIN

• 조인조건절에 사용되는 컬럼의 값이 특정한 범위에 속할 때 사용하는 것
• 조인조건절에 between A and B 사용

---

응용

• 연봉에 대한 소득세액 나타내기

-- [SQL 1992 CODE]
select employee_id as 사원번호
	, first_name || ' ' || last_name as 사원명
    , to_char(nvl(salary + (salary * commission_pct)
    						, salary) * 12,'999,999') as 연봉
    , to_char(trunc(
    	nvl(salary + (salary * commission_pct), salary) 
        		* 12 * taxpercent, 0), '99,999') as 소득세액
from employees E, tbl_taxindex T
where nvl(salary + (salary * commission_pct), salary) 
	* 12 between T.lowerincome and T.highincome
order by 연봉;
    
-- [SQL 1999 CODE]
select emplyee_id as 사원번호
	, first_name || ' ' || last_name as 사원명
    , to_char(nvl(salary + (salary * commission_pct)
    						, salary) * 12,'999,999') as 연봉
    , to_char(trunc(
    	nvl(salary + (salary * commission_pct), salary) 
        		* 12 * taxpercent, 0), '99,999') as 소득세액
from employee E join tbl_taxindex T
ON nvl(salary + (salary * commission_pct), salary) 
	* 12 between T.lowerincome and T.highincome
order by 연봉;

---

정리

-> local_hr에서작업한것