I am typing the below code and it is returning me "ORA-00923: FROM keyword not found where expected". What is happening?
SELECT
max(alias.id) AS "id",
(SELECT alias.name FROM EXAM WHERE alias.id = alias.id ) AS "REF",
alias.name
FROM EXAM alias
GROUP BY alias.name
ORDER BY alias.name ASC;
Here's a fiddle: http://sqlfiddle.com/#!4/537e2/1
alias.name
column, your GROUP BY is based on it. Why do you need an extra subquery?WHERE alias.id = alias.id
will always be true. So do you want every row fromexam
?