北京紫光数智科技有限公司笔试题

我:
1、
SELECT DEPT_ID ,TO_CHAR(TJSJ_DATE,‘YYYY-MM’),max(FDL)
FROM FACT_DAY_SC
GROUP BY DEPT_ID ,TO_CHAR(TJSJ_DATE,‘YYYY-MM’)
我:
2、
SELECT T1.DEPT_ID,T1.TJSJ_DATE,
CASE WHEN T1.FDL < T2.FDL THEN T2.FDL ELSE T1.FDL END
FROM FACT_DAY_SC T1,
FACT_DAY_SC T2
WHERE T1.DEPT_ID = ‘1000000’
AND T1.DEPT_ID = T2.DEPT_ID
AND T2.TJSJ_DATE = T1.TJSJ_