hi
when i try to execute i am getting error
ORA-00933: SQL command not properly ended
plz help me if i remove order by also same error
when i try to execute i am getting error
ORA-00933: SQL command not properly ended
plz help me if i remove order by also same error
Code:
select * from (select job,Sal,dno from emp1) pivot(sum(Sal) for dno in(10,11,12,13,14)) order by 1;
Comment