Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- *
- FROM
- (
- SELECT
- STUDENTID,
- SUBJECTCODE,
- SUBJECTNAME,
- STUDYPROGRAMNAME,
- SCHOOLPERIODE,
- INDEXPOINT,
- SUBJECTID,
- COURSESTUDYPROGRAMID,
- TOTALCHANGE,
- ACTIVESTATUS,
- ROWNUM rnum,
- TOTALROWS
- FROM
- (
- SELECT
- ZZZ.*,
- COUNT( * ) over ( ) TOTALROWS
- FROM
- (
- SELECT
- *
- FROM
- (
- SELECT
- FG.*,
- ( FG.SCHOOLYEAR || '/' || FG.SEMESTER ) SCHOOLPERIODE,
- C.TOTALCHANGE,
- C.ACTIVESTATUS
- FROM
- FINALGRADE FG
- LEFT JOIN (
- SELECT
- STUDENTID,
- SUBJECTID,
- ACTIVESTATUS,
- SCHOOLYEAR,
- SEMESTER,
- COUNT( STUDENTID ) TOTALCHANGE
- FROM
- COMPLETECOURSEPOINTCHANGE
- WHERE
- APPROVALSTATUS IS NULL
- GROUP BY
- STUDENTID,
- SUBJECTID,
- SCHOOLYEAR,
- SEMESTER,
- ACTIVESTATUS
- ) C ON (
- FG.STUDENTID = C.STUDENTID
- AND FG.SUBJECTID = C.SUBJECTID
- AND FG.SCHOOLYEAR = C.SCHOOLYEAR
- AND FG.SEMESTER = C.SEMESTER
- )
- WHERE
- FG.STUDENTID = '1101130009'
- )
- ) ZZZ
- ) a
- WHERE
- ROWNUM <= 20
- )
- WHERE
- rnum >= 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement