select * from (select * from tl_qlsoft_cql_qlcheck_qlstye_bw_bj where chgJrewightnum !='/' and chgjscore !='/') t where chbwid=22
-------------
select chgJrewightnum,chgjscore * CAST(chgJrewightnum AS FLOAT) + CAST(chgjscore AS FLOAT) as count3 from (select * from tl_qlsoft_cql_qlcheck_qlstye_bw_bj where chgJrewightnum !='/' and chgjscore !='/') t where chbwid=22
-------------------
select count( distinct(gjzxbhNO)) from tl_qlsoft_cql_qlcheck_qlstye_bw_gj_checkDispd where
================
select isnull( sum( CAST( isnull(chgjrescore,0) AS FLOAT)) ,0 ) from (select * from tl_qlsoft_cql_qlcheck_qlstye_bw_bj where chgjrescore !='/' ) t where chbwid=29