Differences

This shows you the differences between two versions of the page.

--- kurs:correlated_subquery [2020/06/02 09:26]
admin
+++ kurs:correlated_subquery [2022/03/15 10:39] (current)
admin
@@ Line 1: / Line 1: @@
+<code>
+with cte_multiple_last_names as (
+select last_name,
+       count(*) c
+  from hr.employees
+  group by last_name
+  having count(*) > 1
+  order by c desc
+)
+select employee_id,
+   first_name,
+   last_name
+from hr.employees where last_name
+  in (select last_name from cte_multiple_last_names)
+select
+  emp.first_name,
+  emp.last_name
+from
+  hr.employees emp
+where
+  (select count(last_name) from hr.employees emp_sub where emp_sub.last_name = emp.last_name) > 1
 <code>
 select first_name, last_name, e.employee_id, c from employees e,

dokuwiki