Differences

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

--- kurs:group_by_beispiele [2014/09/10 21:22]
127.0.0.1 external edit
+++ kurs:group_by_beispiele [2020/05/18 11:25] (current)
admin
@@ Line 1: / Line 1: @@
+<code>
+select
+    department_name,
+    count(*) c
+from employees e join departments d
+on e.department_id = d.department_id
+group by
+    department_name
+having count(*) >= 5
+order by c desc
+</code>
 <code>
 with ym as (

dokuwiki