Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT qst.QUE_NAME,
- (SELECT sec2.SECTION_NAME AS "sectionName",
- sec2.SECTION_ID_PK AS "sectionId",
- sec2.SECTION_SEQUENCE AS "sequence",
- CASE(sec2.ENABLE_SCORING)
- WHEN '1'
- THEN 'true'
- ELSE 'false'
- END AS "hasScore",
- sec2.SECTION_WEIGHTAGE,
- sec2.SEC_TOTAL_SCR_WEIGHTAGE,
- sec2.SECTION_TYPE
- FROM MS_XRQ_SECTION sec2
- WHERE sec2.section_category=2
- AND sec2.SECTION_QUESTNR_FK=qst.INTERNAL_QUESTNR_ID
- )
- FROM MS_XRQ_QUESTIONNAIRE qst
- WHERE qst.INTERNAL_QUESTNR_ID= 'Questionnaire-3032';
- SELECT qst.QUE_NAME FROM MS_XRQ_QUESTIONNAIRE qst WHERE qst.INTERNAL_QUESTNR_ID= 'Questionnaire-3032';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement