记一次简单的sql优化

select round(sum(qj0109)/10000,1) from qylist where sfmsqx='y' and lybmhy!='';

进行优化

select round(sum(b.qj0109)/10000,1) from (select a.qj0109 from qylist a where  a.sfmsqx='y' and a.lybmhy!='') b

posted @ 2019-05-09 21:34  听风的dog  阅读(179)  评论(0编辑  收藏  举报