Hi everybody,

I've googled this question but didn't find anything relevant.

How can I create this query in MySQL?

select *, row_number() over (partition by GroupID order by DateField DESC) as RowNum from myTable

?

Thanks in advance.