Value Members

1.  final def !=(arg0: Any): Boolean

   Definition Classes

   Any

2.  final def ##: Int

   Definition Classes

   Any

3.  final def ==(arg0: Any): Boolean

   Definition Classes

   Any

4.  final def asInstanceOf[T0]: T0

   Definition Classes

   Any

5.  def getClass(): Class[_ <: AnyVal]

   Definition Classes

   AnyVal → Any

6.  final def isInstanceOf[T0]: Boolean

   Definition Classes

   Any

7.  def toString(): String

   Definition Classes

   Any

8.  def window[Res](agg: (QueryExpressionBuilder[Out]) => Of[Out, Res])(implicit In: scalaql.Tag[In], flatten: TupleFlatten[(Out, Res)]): WindowDsl[In, Out, Res, Out]

   Entrypoint for building a windowed query - equivalent of plain SQL window functions.

   Entrypoint for building a windowed query - equivalent of plain SQL window functions.

   Example:

   select[Order]
   .window(
     _.avgBy(_.unitPrice)
   )
   .over(
     _.partitionBy(_.customerId)
      .orderBy(_.orderDate.desc)
   )

   Res

   window function result

   agg

   window function aggregation or ranking

   returns

   an entrypoint for defining window functions

   See also

   SQL window functions