You must Sign In to post a response.
  • Category: .NET

    Query in row_number()

    select desig_id, row_number() over (order by desig_id ) as id from m_designation

    this query sql server result is ok
    but i used DBVisualizer personal 6.0.9.
    ERROR:

    select desig_id, row_number() over (order by desig_id ) as id from m_designation;
    12:50:17 [SELECT - 0 row(s), 0.000 secs] [Error Code: 0, SQL State: 42601] ERROR: syntax error at or near "over"
    ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]


    How is handle .
    Pls Hlp.
    Adv Tks.
  • #222736
    over is also not supported in SQL 2005


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.