Selecto.Window.Spec (Selecto v0.3.8)

Specification for a window function operation.

Link to this section Summary

Types

t()

window_function()

Link to this section Types

t()

@type t() :: %Selecto.Window.Spec{
  alias: String.t() | nil,
  arguments: [String.t()] | nil,
  frame: Selecto.Window.Frame.t() | nil,
  function: window_function(),
  id: String.t(),
  opts: keyword(),
  order_by: [String.t() | {String.t(), :asc | :desc}] | nil,
  partition_by: [String.t()] | nil
}

window_function()

@type window_function() ::
  :row_number
  | :rank
  | :dense_rank
  | :percent_rank
  | :ntile
  | :lag
  | :lead
  | :first_value
  | :last_value
  | :nth_value
  | :cume_dist
  | :sum
  | :avg
  | :count
  | :min
  | :max
  | :stddev
  | :variance