3 ms·
Nice! Should be easy to do max instead of count. Then top instead of max. Then top3 breaks the model.
by alquemist 6y ago
Nice! Should be easy to do max instead of count. Then top instead of max. Then top3 breaks the model.
- sergeykish 6y agoYes, should be max(count). I've lost you with top3. # select * from (select count from (select count(y.i), y.d from y group by y.d) _ limit 2) b, (select count(y.i), y.d from y group by y.d) a; count | count | d -------+-------+--- 1 | 1 | 2 2 | 1 | 2 1 | 2 | 1 2 | 2 | 1 (4 rows)
- alquemist 6y agotop - max value in the group top3 - max 3 values in the group