如何使用count命令

Question

SELECT        EMP_MASTER.EMP_NAME, SF_STR.SFS_NAME, SFT_MAS.TER_NAME
FROM            SF_STR INNER JOIN
                     EMP_MASTER ON SF_STR.SFS_CODE = EMP_MASTER.CMI_RT_SFS_CODE AND SF_STR.SFS_CODE = EMP_MASTER.CMI_TPC_SFS_CODE AND 
                     SF_STR.SFS_CODE = EMP_MASTER.E_SFS_CODE INNER JOIN
                     SFT_MAS ON SF_STR.SFS_CODE = SFT_MAS.SFS_CODE CROSS JOIN
                     DCR_LD INNER JOIN
                     DR_MAS ON DCR_LD.DR_CODE = DR_MAS.DR_CODE

Answer 1

您是否尝试将计数添加到所有字段？

SELECT        count(*)
FROM            SF_STR INNER JOIN
                 EMP_MASTER ON SF_STR.SFS_CODE = EMP_MASTER.CMI_RT_SFS_CODE 
AND SF_STR.SFS_CODE = EMP_MASTER.CMI_TPC_SFS_CODE AND 
                 SF_STR.SFS_CODE = EMP_MASTER.E_SFS_CODE INNER JOIN
                 SFT_MAS ON SF_STR.SFS_CODE = SFT_MAS.SFS_CODE CROSS JOIN
                 DCR_LD INNER JOIN
                 DR_MAS ON DCR_LD.DR_CODE = DR_MAS.DR_CODE