SELECT DISTINCT EMP_NO
FROM EMPLOYEE E
ORDER BY EMP_NO
For some reason LIMIT does not seem to work in Oracle .I use dbvisualizer and I always get
" ORA-00933: SQL command not properly ended" when I use LIMIT .
I tried the simplest queries but I dont seem to get it .Even the db visualizer is not seeing it as a reserved work . Am I doing something wrong ?