Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. SELECT qst.QUE_NAME,
  2. (SELECT sec2.SECTION_NAME AS "sectionName",
  3. sec2.SECTION_ID_PK AS "sectionId",
  4. sec2.SECTION_SEQUENCE AS "sequence",
  5. CASE(sec2.ENABLE_SCORING)
  6. WHEN '1'
  7. THEN 'true'
  8. ELSE 'false'
  9. END AS "hasScore",
  10. sec2.SECTION_WEIGHTAGE,
  11. sec2.SEC_TOTAL_SCR_WEIGHTAGE,
  12. sec2.SECTION_TYPE
  13. FROM MS_XRQ_SECTION sec2
  14. WHERE sec2.section_category=2
  15. AND sec2.SECTION_QUESTNR_FK=qst.INTERNAL_QUESTNR_ID
  16. )
  17. FROM MS_XRQ_QUESTIONNAIRE qst
  18. WHERE qst.INTERNAL_QUESTNR_ID= 'Questionnaire-3032';
  19.  
  20. 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