想这样使用group by .

Question

select t1.*,ATTENDANCE_TYPE.ATTEND_PRICE
from (
SELECT ATTENDANCE_REC.EMPNO, 
       ATTENDANCE_REC.ATTEND_NO, 
       COUNT(ATTENDANCE_REC.ATTEND_NO) as ATTEND_NUM,  ---这里统计这段时间这种考勤共几次
       
       COUNT(ATTENDANCE_REC.ATTEND_NO)*ATTENDANCE_TYPE.ATTEND_PRICE as ATTEND_SALARY
FROM ATTENDANCE_REC,ATTENDANCE_TYPE
WHERE ATTENDANCE_REC.ATTEND_NO=ATTENDANCE_TYPE.ATTEND_NO AND 
      ATTENDANCE_REC.REC_DATE>= TO_DATE('10/10/2004','MM/DD/YYYY') AND
      ATTENDANCE_REC.REC_DATE<= TO_DATE('05/05/2005','MM/DD/YYYY') 
GROUP BY ATTENDANCE_REC.EMPNO, ATTENDANCE_REC.ATTEND_NO) t1,
ATTENDANCE_TYPE 
where t1.ATTEND_NO = ATTENDANCE_TYPE.ATTEND_PRICE

Answer 1

这样试试：
SELECT ATTENDANCE_REC.EMPNO, 
       ATTENDANCE_REC.ATTEND_NO, 
       COUNT(ATTENDANCE_REC.ATTEND_NO) as ATTEND_NUM,  ---这里统计这段时间这种考勤共几次
       ATTENDANCE_TYPE.ATTEND_PRICE,
       COUNT(ATTENDANCE_REC.ATTEND_NO)*ATTENDANCE_TYPE.ATTEND_PRICE as ATTEND_SALARY
       FROM ATTENDANCE_REC,ATTENDANCE_TYPE
       WHERE ATTENDANCE_REC.ATTEND_NO=ATTENDANCE_TYPE.ATTEND_NO AND 
         ATTENDANCE_REC.REC_DATE>= TO_DATE('10/10/2004','MM/DD/YYYY') AND
         ATTENDANCE_REC.REC_DATE<= TO_DATE('05/05/2005','MM/DD/YYYY') 
           GROUP BY ATTENDANCE_REC.EMPNO, ATTENDANCE_REC.ATTEND_NO,ATTENDANCE_TYPE.ATTEND_PRICE