Mysql supports 'partition by' analytical function?

[Bhanu Nadendla]

Hi All,

I am wroking on Migrating my Oracle databse to Mysql where I need to convert all oracle syntax in the views to Mysql syntax.

one of them is partition function.

Oracle query:
select
COL1,
COL2,
row_number() over (partition by COL1 order by COL2 desc) as rate_index
from Table1;

is there any way to use same logic in the Mysql.

please help me

Thanks
Prakash



Edited 1 time(s). Last edit at 09/05/2008 04:42AM by Bhanu Nadendla.