17,086
社区成员
发帖
与我相关
我的任务
分享
select rownum,row_.*, rownum jres_db_rownum_
from (select sa.ADJUST_ID,
sa.STAFF_CODE,
-- sa.SERIAL_NO,
sa.CURR_DT,
-- sa.DEAL_TM,
sa.SALARY_SUBJECT,
sa.OCCUR_BALANCE,
sa.BRANCH_NO,
sa.TEAM_NO,
sa.OP_ACCOUNT,
sa.REMARK,
sa.audit_status
from sly_adjustfarerecord sa
where 1 = 1
order by audit_status, curr_dt desc, branch_no) row_