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

    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,
    San.

  2. #2
    Join Date
    Feb 2012
    Posts
    133
    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
  •