select PER_CODE as [EMP CODE], EXC_DATE as LEAVES
from R5EXCEPTIONS
inner join R5PERSONNEL on PER_CODE = EXC_PERSON
上面提到的是我上面的代碼。我想在另一列中計算葉子數。
下面提到的是我的代碼輸出：
代碼輸出
uj5u.com熱心網友回復：
您可以通過對員工代碼進行分組來計算休假次數
Select PER_CODE As [EMP CODE] , COUNT(EXC_DATE) as LEAVES from
R5EXCEPTIONS inner join R5PERSONNEL on PER_CODE = EXC_PERSON
group by PER_CODE
uj5u.com熱心網友回復：
您可以使用聚合 SQL 查詢按日期獲取 PER_CODE 事件的數量。
以下將代表這一點：
select count(PER_CODE) as [EMP VOL], EXC_DATE as LEAVES
from R5EXCEPTIONS
inner join R5PERSONNEL on PER_CODE = EXC_PERSON
Group by EXC_DATE
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/439477.html