Return
-
Title
Error "ORA-01791: not a SELECTed expression" when executing a SELECT DISTINCT..... ORDER BY query -
Description
Running a 'SELECT DISTINCT' query with an ORDER BY clause and getting error
"ORA-01791: not a SELECTed expression"
Here's an example of what is being run
SELECT DISTINCT
EMPLOYEE_ID,
substr(employees.FIRST_NAME,1,3
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.