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

(select dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in (

select dmzz from ydm where dmbh=3300))))

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

select SJDM from ydm where dmbh=3300

union all

select SJDM from ydm where dmbh in

(select dmzz from ydm where dmbh=3300)

union all

select SJDM from ydm where dmbh in

(select dmzz from ydm where dmbh in (

select dmzz from ydm where dmbh=3300))

union all

select SJDM from ydm where dmbh in

(select dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in (

select dmzz from ydm where dmbh=3300)))

union all

select SJDM from ydm where dmbh in

(select dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in

(select dmzz from ydm where dmbh in (

select dmzz from ydm where dmbh=3300))))

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

SELECT COUNT(*) as yhs ,SUM(DF) as df FROM DB2.DFTDF

WHERE (year(rq)*12+month(rq)) between 24015 and 24015

AND dflb=513

and (ZHH,YYH) IN

(SELECT ZHH,YYxH FROM DB2.YDD111 WHERE HYM in

( select SJDM from DB2.ydm where dmbh=3200

union all

select SJDM from DB2.ydm where dmbh in (

select dmzz from DB2.ydm where dmbh=3200)

union all

select SJDM from DB2.ydm where dmbh in (

select dmzz from DB2.ydm where dmbh in (

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

union all

select SJDM 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)))

union all

select SJDM from DB2.ydm where dmbh in (

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