7 Replies Latest reply on Oct 18, 2013 4:25 PM by Steven Hawkins

    Order by query in TEIID

    lawrence jesu Newbie

      Hi,

           The ORDER BY is not working correctly.Though i specified  ORDER BY ENAME in my query the teiid igonres and always executed with first column selection (ECODE).

       

                      select ECODE,ENAME from EMPLOYEE ORDER BY ENAME

       

       

      How to display the employee list  order by ENAME? why my  query executed always  with order by  first column? do i need to do any changes in my query?

      your help could be appreci