Todd Jain wrote:
Goutham Pallipati wrote:use "select rownum, distinct salary from emp order by salary"
I go an ORA-00936 error: missing expression
You have got an error because this query has a syntax error
- DISTINCT can appear right after SELECT only ,and can applied to the whole row,
DISTINCT cannot be applied to individual columns.
The syntax of SELECT statement is: