资源描述:
《sql中select中使用if语句案例》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、selectUNITNAME,WRITER,PHONE,Real_Person_Num,(if(MPOSTSisnull,0,MPOSTS)+if(TPOSTSisnull,0,TPOSTS)+if(WPOSTSisnull,0,WPOSTS))asTOTAL_POSTS,M_Persont,T_Persont,L_Persont,ML3,ML4,ML5,ML6,ML7,ML8,ML9,ML10,HL,ML,LL,TL2,TL3,TL4,TL5,TL6,TL7,TL8,TL9,TL10,TL11,TL12,TL13,LL3,LL4,LL5,LL14,cast(MRAT
2、IOaschar)asMYMRATIO,cast(TRATIOaschar)asMYTRATIO,cast(WRATIOaschar)asMYWRATIO,MPOSTS,TPOSTS,WPOSTS,if(cast(round(ROUND(ML3/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML3/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmbl3,if(cast(round(ROUND(ML4/if(MPOSTS=0,1
3、,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML4/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmbl4,if(cast(round(ROUND(ML5/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML5/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmbl5,if(cast(round(ROUND(ML
4、6/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML6/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmbl6,if(cast(round(ROUND(ML7/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML7/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmbl7,if(cast
5、(round(ROUND(ML8/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML8/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmbl8,if(cast(round(ROUND(ML9/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML9/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%")
6、)asmbl9,if(cast(round(ROUND(ML10/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML10/if(MPOSTS=0,1,MPOSTS),4)*100,1)aschar),"%"))asmlb10,if(cast(round(ROUND(HL/if(TPOSTS=0,1,TPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(HL/if(TPOSTS=0,1,TPOSTS),4)*10
7、0,1)aschar),"%"))ashbl,if(cast(round(ROUND(ML/if(TPOSTS=0,1,TPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(ML/if(TPOSTS=0,1,TPOSTS),4)*100,1)aschar),"%"))asmbl,if(cast(round(ROUND(LL/if(TPOSTS=0,1,TPOSTS),4)*100,1)aschar)="0.0","",concat(cast(round(ROUND(LL/if(TPOSTS