SELECT A.EMPLID, A.SUBJECT, A.CATALOG_NBR, A.DESCR, count ( A.CRSE_ID),A.ACAD_CAREER,A.INSTITUTION,A.STRM,A.CLASS_NBR
FROM PS_CLASS_TBL_SE_VW A
WHERE A.INSTITUTION = :1
AND A.STRM <= :2
AND A.STDNT_ENRL_STATUS = 'E'
GROUP BY A.EMPLID, A.SUBJECT, A.CATALOG_NBR, A.DESCR,A.ACAD_CAREER,A.INSTITUTION,A.STRM,A.CLASS_NBR
HAVING count ( A.CRSE_ID) > 1
  • No labels