how to set row number in sybase query


SELECT DISTINCT Number() rowid,

A.COMP_CODE,A.BRANCH_CODE,A.CURRENCY_CODE,A.GL_CODE,A.CIF_SUB_NO,A.SL_NO,A.CV_AMOUNT,('REVERSAL'+''+'TEST' + '' + A.DESCRIPTION) AS A_DESCRIPTION,B.COMP_CODE,B.BRANCH_CODE,B.CURRENCY_CODE,B.GL_CODE,B.CIF_SUB_NO,B.SL_NO,GETDATE() 'INSERT_DATE' ,GETDATE() 'UPDATE_DATE','0' STATUS

Posted by Bali Shah (1) at 2025-07-21T09:12:20Z

Caught for

Low Length
No Code Block
Non English Post - de
Low Rep