Public Vars
- add-column (clj)
- add-index (clj)
- alter-column (clj)
- alter-table (clj)
- bulk-collect-into (clj)
- columns (clj)
- compare-with (clj)
- composite (clj)
- create-extension (clj)
- create-index (clj)
- create-materialized-view (clj)
- create-or-replace-view (clj)
- create-table (clj)
- create-table-as (clj)
- create-view (clj)
- cross-join (clj)
- delete (clj)
- delete-from (clj)
- distinct (clj)
- do-nothing (clj)
- do-update-set (clj)
- drop-column (clj)
- drop-extension (clj)
- drop-index (clj)
- drop-materialized-view (clj)
- drop-table (clj)
- drop-view (clj)
- erase-from (clj)
- except (clj)
- except-all (clj)
- exclude (clj)
- expr (clj)
- facet (clj)
- fetch (clj)
- filter (clj)
- for (clj)
- from (clj)
- full-join (clj)
- generic-helper-unary (clj)
- generic-helper-variadic (clj)
- group-by (clj)
- having (clj)
- inner-join (clj)
- insert-into (clj)
- intersect (clj)
- into (clj)
- join (clj)
- join-by (clj)
- lateral (clj)
- left-join (clj)
- limit (clj)
- lock (clj)
- modify-column (clj)
- offset (clj)
- on-conflict (clj)
- on-constraint (clj)
- on-duplicate-key-update (clj)
- order-by (clj)
- outer-join (clj)
- over (clj)
- partition-by (clj)
- patch-into (clj)
- records (clj)
- refresh-materialized-view (clj)
- rename (clj)
- rename-column (clj)
- rename-table (clj)
- replace-into (clj)
- returning (clj)
- right-join (clj)
- select (clj)
- select-distinct (clj)
- select-distinct-on (clj)
- select-distinct-top (clj)
- select-top (clj)
- set (clj)
- setting (clj)
- since (clj)
- table (clj)
- timeseries (clj)
- truncate (clj)
- union (clj)
- union-all (clj)
- until (clj)
- update (clj)
- upsert (clj)
- using (clj)
- values (clj)
- where (clj)
- window (clj)
- with (clj)
- with-columns (clj)
- with-data (clj)
- with-recursive (clj)
- within-group (clj)
Back
over (clj)
(source)function
(over & args)
Accepts any number of OVER clauses, each of which
is a pair of an aggregate function and a window function
or a triple of an aggregate function, a window function,
and an alias:
(select :id (over [[:avg :salary] (partition-by :department)]))
Produces: SELECT id, AVG(salary) OVER ()PARTITION BY department)