Mr. Ramasamy.N thanks to u... but.........

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.