Bug #7216 Oracle-like Analytic Function RANK() / DENSE_RANK()
Submitted: 13 Dec 2004 1:23 Modified: 10 Oct 2019 20:57
Reporter: Gabe Jackson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.x ? OS:Any (ALL)
Assigned to: CPU Architecture:Any

[13 Dec 2004 1:23] Gabe Jackson
Description:
Trying to generate a numeric RANK for multiple columns containing strings to do sorting on numerical indices instead of string comparisions in the frontend software.

Oracle has a function to do exactly this, the documentation to the function is here:
http://www.oracle-base.com/articles/9i/RankDenseRankFirstLastAnalyticFunctions.php

A more extensive Document is located here:
http://www.orafaq.com/articles/archives/000060.htm

How to repeat:
-

Suggested fix:
-
[14 Feb 2006 14:21] Valeriy Kravchuk
Thank you for a reasonable feature request. I hope it will be implemented in the foreseeable future.
[10 Oct 2019 20:57] Roy Lyseng
Posted by developer:
 
Implemented in 8.0 with window functions.