In which scenario does Group By not work during a certain type of Load? Add you have to do a Resident Load instead?

[jblomqvist]

Hi,

I seem to recall that Group By is not possible for certain type of loads, and you have to do a Resident Load instead and then a group by.

Can anybody remind me when this rule applies?

[sunny_talwar]

That is true for Order By. Group by works everywhere, whereas, Order by can only work on Resident load