My SQL equivalent for Duplicate row filter , Concatenate, Pivot nodes

Maybe you take a look at this article dealing with duplicates. The other link would give you an example how to use Window functions like rank to control what would count as a duplicate.

MySQL also does support these functions:

https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html

1 Like