Thread: Measures Api group by.

Hi all, I have a table which consists of Whole key prefabricated up of cardinal columns . Let the columns be A,B,C .Now the condition is to have groupby on triad combinations.
1] A,B
2] A,C
3] A
Can this be done through ninefold projections on lonesome Criteria telecommunicate. What are the remaining options.Thanks in advance.

I think that most of the databases let you have both an ORDER BY and a Set BY on a Superior statement. For undecomposable queries, specified as grouping by division, but operation by extremum salary in declivitous arrangement, this strength be comfortable. But, for writer convoluted scenarios you give likely have to use a SubQuery. See the "From SubQuery" example in the SubQuery Showcase.