Non Equi Join:

It is a join condition containing something other than an equal operator. The link between emp and job_grade table has an exampleof a nonequijoin. The relationship between two table is that the salary column in the emp table must be between the value of lowest_sal and highest_sal column of the job_grade table. The relationship is established using an operator other than equal(=).

Example:

SELECT e.emp_name, e.emp_salary, j.gra
FROM emp e, job_grade j
WHERE e.emp_salary BETWEEN j.lowest_sal AND
j.highest_sal;

The above example is based on non-equijion, which will display the employee salary grade based on there salary. The salary must be between any pair of the low and high salary range.



  Tutorials

Popular Links

Contact Us

address Plot No-741,2ND Floor
Opp. Bhagabati Temple,Jayadev Vihar
      Bhubaneswar-751013
      Email: info@silantechnology.com
      Phone: 0674-2361252
address
39877, sundale dr, apt#101, Fremont, California 94538, USA
       Phone: +1(262)388-7619

facebook twitter google linked in

© 2018 Silan Technology. All Rights Reserved