sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(24)

select dmzz from DB2.ydm where dmbh in (

select dmzz from DB2.ydm where dmbh in (

select dmzz from DB2.ydm where dmbh in (

select dmzz from DB2.ydm where dmbh=3200))))

))

***********************************************

select bcm,bsm,count(bsm) as sl

from (

selectbcm,case

when blx='DXB' and bxh like 'DD%' AND BXH NOT LIKE 'DDS%'

then 'JJB'

else 'DZB'

end as bsm

from jldb) as jldb2

group by bcm,bsm

select bcm,bsm,count(bsm) as sl

from (

selectbcm,case

when blx='DXB' and bxh like 'DD%' AND BXH NOT LIKE 'DDS%'

then 'JJB'

else 'DZB'

end as bsm

from jldb

where bzt='OK' and qyrq between '1999-1-1' and '2003-1-3' ) as jldb2

group by bcm,bsm

****************

select bcm,bsm,bxh,count(bsm) as sl

from (

selectbcm,case

when blx='DXB' and bxh like 'DD%' AND BXH NOT LIKE 'DDS%'

then 'JJB'

else 'DZB'

end as bsm,bxh

from jldb

where bzt='OK' and qyrq between '1999-1-1' and '2003-1-3' ) as jldb2

group by bcm,bxh,bsm

**********************************************

with ttt as (select bcm,bxh,bsm,count(bsm) as sl from (selectbcm,bxh,casewhen blx='DXB' and bxh like 'DD%' AND BXH NOT LIKE 'DDS%' then '机械表' else 'DZB' end

as bsm from jldb where bzt='OK' and qyrq<='2002-2-2') as jldb2 group by bcm,bxh,bsm),

sss as (select bcm,bxh,bsm,count(bsm) as sl1 from (selectbcm,bxh,casewhen blx='DXB' and bxh like 'DD%' AND BXH NOT LIKE 'DDS%' then '机械表' else 'DZB' end

as bsm from jldb where bzt='OK' and qyrq<='2000-1-1') as jldb2 group by bcm,bxh,bsm)

select ttt.bcm,ttt.bxh,ttt.bsm,value(ttt.sl,0) as sl1,value(sss.sl1,0)as sl2,(value(ttt.sl,0)-value(sss.sl1,0)) as sl3 from ttt full join sss

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-24.html