Oracle DB Error ORA-01791 not a SELECTed expression

The following is the cause of this error:

There is an incorrect ORDER BY item. The query is a SELECT DISTINCT query with an ORDER BY clause. In this context, all ORDER BY items must be constants, SELECT list expressions, or expressions whose operands are constants or SELECT list expressions.

Action you can take to resolve this issue: Remove the inappropriate ORDER BY item from the SELECT list and retry the statement.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related