Versions Compared

Old Version 13

changes.mady.by.user Vladimir Ozerov Ozerov

Saved on

compared with

New Version 14

changes.mady.by.user Vladimir Ozerov Ozerov

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titleBefore
linenumberstrue
SELECT dept.name
FROM dept
WHERE dept.id IN (SELECT emp.dept_id FROM emp GROUP BY emp.dept_id HAVING COUNT(*) > 10>10)


Code Block
languagesql
titleAfter
linenumberstrue
SELECT dept.name
FROM dept JOIN (SELECT emp.dept_id FROM emp GROUP BY emp.dept_id HAVING COUNT(*) > 10>10) emp_subquery ON dept.id=emp_subquery.dept_id

...