 Window Functions    
MariaDB starting with 10.2Window functions were first introduced in MariaDB 10.2.0. 
Window functions perform calculations across a set of rows related to the current row  

Title
Description



 Window Functions Overview
 Window functions perform calculations across a set of rows related to the current row. 


 AVG
 Returns the average value. 


 BIT_AND
 Bitwise AND. 


 BIT_OR
 Bitwise OR. 


 BIT_XOR
 Bitwise XOR. 


 COUNT
 Returns count of non-null values. 


 CUME_DIST
 Window function that returns the cumulative distribution of a given row. 


 DENSE_RANK
 Rank of a given row with identical values receiving the same result, no skipping. 


 FIRST_VALUE
 Returns the first result from an ordered set. 


 JSON_ARRAYAGG
 Returns a JSON array containing an element for each value in a given set of JSON or SQL values. 


 JSON_OBJECTAGG
 Returns a JSON object containing key-value pairs. 


 LAG
 Accesses data from a previous row in the same result set without the need for a self-join. 


 LAST_VALUE
 Returns the last value in a list or set of values. 


 LEAD
 Accesses data from a following row in the same result set without the need for a self-join. 


 MAX
 Returns the maximum value. 


 MEDIAN
 Window function that returns the median value of a range of values. 


 MIN
 Returns the minimum value. 


 NTH_VALUE
 Returns the value evaluated at the specified row number of the window frame. 


 NTILE
 Returns an integer indicating which group a given row falls into. 


 PERCENT_RANK
 Window function that returns the relative percent rank of a given row. 


 PERCENTILE_CONT
 Continuous percentile. 


 PERCENTILE_DISC
 Discrete percentile. 


 RANK
 Rank of a given row with identical values receiving the same result. 


 ROW_NUMBER
 Row number of a given row with identical values receiving a different result. 


 STD
 Population standard deviation. 


 STDDEV
 Population standard deviation. 


 STDDEV_POP
 Returns the population standard deviation. 


 STDDEV_SAMP
 Standard deviation. 


 SUM
 Sum total. 


 VAR_POP
 Population standard variance. 


 VAR_SAMP
 Returns the sample variance. 


 VARIANCE
 Population standard variance. 


 Aggregate Functions as Window Functions
 It is possible to use aggregate functions as window functions. 


 ColumnStore Window Functions
 Summary of window function use with the ColumnStore engine 


 Window Frames
 Some window functions operate on window frames. 


  Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.  

    
{'path': 'public/docs/mariadb/window-functions/index.html', 'source': 'DevDocs.IO'}