neuralib.sqlp.func_win

SQL window functions.

https://www.sqlite.org/windowfunctions.html https://www.sqlite.org/windowfunctions.html#built_in_window_functions

neuralib.sqlp.func_win.window_def(name=None, *, order_by=None, partition_by=None)[source]
Parameters:
  • name (str | None)

  • order_by (list | None)

  • partition_by (list | None)

Return type:

SqlWindowDef

neuralib.sqlp.func_win.row_number()[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.rank()[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.dense_rank()[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.percent_rank()[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.cume_dist()[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.ntile(n)[source]
Parameters:

n (int)

Return type:

SqlWindowFunc

neuralib.sqlp.func_win.lag(expr, offset=None, default=None)[source]
Parameters:

offset (int)

Return type:

SqlWindowFunc

neuralib.sqlp.func_win.lead(expr, offset=None, default=None)[source]
Parameters:

offset (int)

Return type:

SqlWindowFunc

neuralib.sqlp.func_win.first_value(expr)[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.last_value(expr)[source]
Return type:

SqlWindowFunc

neuralib.sqlp.func_win.nth_value(expr, n)[source]
Parameters:

n (int)

Return type:

SqlWindowFunc