戻る
-
タイトル
Error "ORA-01791: not a SELECTed expression" when executing a SELECT DISTINCT..... ORDER BY query -
説明
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