Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015

    Unanswered: RANK Function in Sybase

    Hi Friends,

    I am new to Sybase but I am familiar with Oracle. I used RANK() but it thows the below error;

    "SELECT Failed. 156: Incorrect Syntax near the keyword 'OVER' ".

    Below is the query I used..

    SELECT Surname, Sex, Salary, RANK() OVER (PARTITION BY Sex
    ORDER BY Salary DESC) AS RANK FROM Employees.

    Please assist me on this.

    Warm Regards,

  2. #2
    Join Date
    Feb 2012
    is this sybase IQ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts