Bug #35893 analytiacal function like RANK etc to be implemented

• Submitted: 8 Apr 2008 9:36
• Modified: 10 Apr 2008 14:26
• Reporter: Logesh Velusamy
• Status: Verified
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• Version: 5.0
• OS: Any
• CPU Architecture: Any
• Tags: analytiacal function like RANK etc to be implemented

[8 Apr 2008 9:36] Logesh Velusamy

Description:
implemention of SQL-99 OLAP (on-line analytical processing) extensions

<aggregate function> (<field>) OVER (PARTITION BY <field2> ORDER BY <field3> ASC ROWS 2 PRECEDING )

Such as RANK, DENSE_RANK, ROW_NUMBER etc

How to repeat:
Feature not available

Suggested fix:
Please implement the required functions

[10 Apr 2008 14:26] Valeriy Kravchuk

Thank you for a reasonable feature request.

[22 Oct 2015 19:35] Daniël van Eeden

Related to (or duplicate of?):
Bug #28957 	Ordered Analytical Functions