| select count(*) total_lines from ( select @y:=@y+1 num, c.* from ( select b.depart_no, b.depart_name, sum(a.accept_money)/100 total_money from tsc_accept a left join tbosc_sc_base b on a.sc_no = b.sc_no where (b.close_date is null or year(b.close_date)>=${year(p_sign_date)}) and year(a.accept_date)=${year(p_sign_date)} and a.accept_date<='${p_sign_date}' and ${rights("b.depart_no",hierarchy,'',departs)} group by b.depart_no,b.depart_name )c, (SELECT @y:=0) z order by c.total_money desc ) t |
