Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/Non_Inner_or_Equal_Join.sql

Created October 14, 2021 18:48
Show Gist options
  • Save vvgsrk/8e8ad218a5860adfd0377fde256b6ba5 to your computer and use it in GitHub Desktop.
Save vvgsrk/8e8ad218a5860adfd0377fde256b6ba5 to your computer and use it in GitHub Desktop.
Download ZIP
Non-Inner/Equal Join
Raw
Non_Inner_or_Equal_Join.sql
SELECT e.last_name, e.salary, j.grade
FROM employees e, job_grades j
WHERE e.salary BETWEEN j.lowest_sal AND j.highest_sal;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment