Need way to group by two times

[TheBuzzer]

Hi. I have this problem

Group by will make the table only show a value of that group once.

So lets say there was 1000 results without group by.
500 with a single group by.

But now i want to do another group by to filter it down more to like 250 results

However if you try to do group by group1,group2 it ends up with more results like 700 because it group1 and group2 together is now a unique trigger not filter by one and filter by the other.

So anyway to do something like this?

[blocblue]

Why not make the first group by a subquery of the second??

[TheBuzzer]

Thx, i figure out I could do that. Never knew you can do that before.