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"