This message was deleted.

Hi Inault, you are close ...

select ...
from table t1
cross join table t2
where t2.keyCount <= t1.keyCount

With Druid you cannot use inequalities in the join condition, so unless there is a higher level grouping in your query that gives you join columns, you have to use cross join and then apply the inequality filter condition afterwards. Let us know if you have any issues doing it this way.

oh, with cross join we can do that ? Thanks ! I'll try and let you know if it solves my problem.