示例SQL:
- 当SEX=man时,MAN_FLAG=1
- 当SEX=woman时,MAN_FLAG=0
SELECT * FROM student.CHOOSE_CLASS_INFO
WHERE MAN_FLAG = CASE
WHEN ((SELECT SEX FROM student.STUDENT_INFO WHERE STUDENT_NUMBER='001') = 'man') THEN '1'
WHEN ((SELECT SEX FROM student.STUDENT_INFO WHERE STUDENT_NUMBER='001') = 'woman') THEN '0'
END