Hi ,

I've an issue on my query and I've attached the snap of that, can anyone tell me what is the actual problem, thanks in advance.

Solution

Hi Thanigai,

When you GROUP BY one or more columns, those columns, and only those, may appear in the SELECT without an aggregating function.

That said, why are you not using an Aggregate? With an Aggregate you an also group, but it's less error prone. Always use Aggregates unless you really know what you are doing, and why.

Solution

Thanigai Arasu wrote:

Hi ,

I've an issue on my query and I've attached the snap of that, can anyone tell me what is the actual problem, thanks in advance.

you must put all columns of the SELECT in the GROUP BY


Hi Thanigai,

Yes you have to add all the group by column in your select.Similar you can achieve by using aggregate,Just need to select which column you want to group by by right click of aggregate output. 


Thanks,

Manish Pandey

Thank you all for the quickest reply. Now i understood.