title: Order by not working in SQL analytical functions
body: <pre><code>create table Employee 
  (
   Ename varchar (255),
   empno  integer primary key,
   deptno integer ,
   salary integer
   );
  </code></pre>
  
  <p>`</p>
  
  <pre><code>insert into Employee values ('Gauhar khan',1000,10,5000);
  insert into Employee values ('Gauri sharma',1001,10,6000);
  insert into Employee values ('Gauresh verma',1002,10,7000);
  insert into Employee values ('Raja ashokan',1003,20,8000);
  insert into Employee values ('Divya Nair',1004,20,19000);
  insert into Employee values ('Ashwin Thakare',1005,20,10000);
  insert into Employee values ('Uttam Thapa',1006,30,7800);
  insert into Employee values ('Krutagnya Thakker',1007,30,11000);
  insert into Employee values ('Kritika manocha',1008,30,12000);
  </code></pre>
  
  <p>`</p>
  
  <pre><code>select * from Employee;
  </code></pre>
  
  <p>`</p>
  
  <pre><code>SELECT empno,
         deptno,
         salary,
         SUM(salary) OVER(PARTITION BY deptno ORDER BY salary) AS dept_running_total
  FROM Employee;
  </code></pre>
  
  <p>It returns the error :</p>
  
  <pre><code>Error: near line 1: near "(": syntax error
  </code></pre>
  
  <p>I have tried using only partition by clause as well still returned the same error. Please guide me in resolving the error. I tried running this over various online sql editors. </p>