cross tabulation query related to pivot operator

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nagireddydhana
    New Member
    • Aug 2013
    • 1

    cross tabulation query related to pivot operator

    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

    Code:
    select * from (select job,Sal,dno from emp1) pivot(sum(Sal) for dno in(10,11,12,13,14)) order by 1;
    Last edited by Rabbit; Aug 19 '13, 06:57 AM. Reason: Please use code tags when posting code or formatted data.
  • gaurishere
    New Member
    • Sep 2013
    • 9

    #2
    no i got the results properly with above query with both query

    Comment

    Working...