• Before we had the OVER() clause for aggregates, this could only be achieved with a subquery or a join with a derived table.

    I am realy lucky: I am having a hard time getting the wright answer from a query that is very complicated, trying to manipulate the data with group by, with, subqueries, etc. and maybe my answer to it would be the over(partition) case that, yesterday, I did not know the existence ...

    I'll have to work on it more, but at least I understand better...

    Thanks Hugo

    Thanks da-zero

    ... and ya, thanks to UK and US for the good laughs:-D