load rowno() script in SQL

[#1]

Hi Everybody...

the trigger is my script in qlikview expression wont work becouse it dont have RowNo()

this is my script(i got this script from mr/mrs.settu in this community) :

if(RowNo()=1,

    if(DEBET<1,

        (LSALDO-OUTCOME),

        (LSALDO+INCOME)),

    if(INCOME<1,Rangesum(Above(Column(3)),-Sum(OUTCOME)),   

    Rangesum(Above(Column(3)),Sum(INCOME))))

and.. this is my qlikview table(with wrong values Rangesum)

i create RowNo in expression.. not in main script.

can i create LOAD RowNo() in main script with my SQL Database script

maybe its like :

Load RowNo(),

select  * from username_table

where ..... = '......'

can anyone give me the correct load RowNo() script in SQL