Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
<hypothetical set function> ::= <rank function type> <left paren> <hypothetical set function value expression list> <right paren> <within group specification> <rank function type> ::= RANK | DENSE_RANK | PERCENT_RANK | CUME_DIST
Example:
CREATE TABLE table1 (column1 int);
INSERT INTO table1 VALUES (NULL), (3), (8), (13), (7), (6), (20), (NULL), (NULL), (10), (7), (15), (16), (8), (7), (8), (NULL);
SELECT rank(6) WITHIN GROUP (ORDER BY column1) FROM table1;
2
Attachments
Attachments
Issue Links
- links to