Skip to content Skip to sidebar Skip to footer

Really Simple Sql Not A Group By Expression - Oracle

I tried to read about not a group by expression errors from some other posts, but all of them mention group functions such as MAX, MIN, etc. I'm not using any of it and it's a real

Solution 1:

The GROUP BY is not useful outside of the context of an aggregate function like MIN() MAX() SUM() COUNT(), except perhaps to deduplicate rows. Just remove it. If you are looking to deduplicate results, use DISTINCT instead. If you use DISTINCT, it won't be of much value unless you are more specific about the columns in the SELECT list, excluding the primary key column.

SELECTDISTINCT * 
FROM 
  AD_VOARNET_ATENDIMENTO_PISTA 
WHERE IS_CLOSED = 0ORDERBY PREFIXO

GROUP BY is sometimes confused with ORDER BY. You already have an ORDER BY PREFIX0,

Post a Comment for "Really Simple Sql Not A Group By Expression - Oracle"