This extends SQL window function for analytical queries interview questions – Part 1 Analytic function construct
|
1 2 3 4 5 6 |
analytic_function_name([argument_list]) OVER ( [PARTITION BY partition_expression,…] [ORDER BY sort_expression, … [ASC|DESC]]) |
The analytic function names can be RANK(), DENSE_RANK(), ROW_NUMBER(), MIN(column), MAX(column), SUM(column), COUNT(), AVG(column), FIRST_VALUE(column), LAST_VALUE(column), NTH_VALUE(column, n), LEAD(return_value ,offset [,default]), LAG(return_value ,offset…
(Visited 9 times, 1 visits today)