스터디/Oracle30 [Oracle] Case 문 테이블 조회 SELECT class_cd, student_no,student_nm, kor FROM tb_grade; CASE 문 SELECT CLASS_CD, STUDENT_NO, STUDENT_NM, KOR AS KOR_SCORE, CASE WHEN KOR >= 90 AND KOR = 80 AND KOR = 70 AND KOR = 60 AND KOR 2021. 4. 9. [Oracle] JOIN / LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN 기본 테이블 조회 select * from TB_GRADE; select * from TB_CLASS_INFO; Join select * from TB_GRADE A, TB_CLASS_INFO B where A.class_cd = B.class_cd; select * from TB_GRADE A join TB_CLASS_INFO B on A.class_cd = B.class_cd; 테이블 조회 select * from TB_GRADE_08; select * from TB_GRADE_09; SELECT * FROM tb_grade_08 A JOIN tb_grade_09 B ON A.test_cd = B.test_cd; SELECT * FROM tb_grade_08 A LEFT JOIN tb_grade_09.. 2021. 4. 9. 이전 1 ··· 5 6 7 8 다음
