Interface WinAggFrameContext

    • Method Detail

      • index

        Expression index()
        Returns the index of the current row in the partition. In other words, it is close to ~ROWS BETWEEN CURRENT ROW. Note to use startIndex() when you need zero-based row position.
        Returns:
        the index of the very first row in partition
      • startIndex

        Expression startIndex()
        Returns the index of the very first row in partition.
        Returns:
        index of the very first row in partition
      • endIndex

        Expression endIndex()
        Returns the index of the very last row in partition.
        Returns:
        index of the very last row in partition
      • hasRows

        Expression hasRows()
        Returns the boolean expression that tells if the partition has rows. The partition might lack rows in cases like ROWS BETWEEN 1000 PRECEDING AND 900 PRECEDING.
        Returns:
        boolean expression that tells if the partition has rows
      • getFrameRowCount

        Expression getFrameRowCount()
        Returns the number of rows in the current frame (subject to framing clause).
        Returns:
        number of rows in the current partition or 0 if the partition is empty
      • getPartitionRowCount

        Expression getPartitionRowCount()
        Returns the number of rows in the current partition (as determined by PARTITION BY clause).
        Returns:
        number of rows in the current partition or 0 if the partition is empty