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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0 OS:Any
Assigned to: 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