Oracle Sql query having error ORA-00933

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kinzarazzaq09
    New Member
    • Oct 2016
    • 1

    Oracle Sql query having error ORA-00933

    select loc from emp e, dept d having count(e.deptno) = 0 or sal <= min(sal) and d.dname = 'SALES' and count(ename) >=2 and sal < avg(sal) group by loc where e.deptno != d.deptno;

    ORA-00933: SQL command not properly ended

    This error I get when I run this command on oracle, can anyone help me resolve this error?
Working...