inblog logo
|
silver
    SQL문제풀기

    [SQL문제풀기] Python 개발자 찾기

    silver's avatar
    silver
    Nov 24, 2024
    [SQL문제풀기] Python 개발자 찾기
     

    문제

    school.programmers.co.kr
    https://school.programmers.co.kr/learn/courses/30/lessons/276013
     

    내가 작성한 정답

    SELECT ID, EMAIL, FIRST_NAME, LAST_NAME FROM DEVELOPER_INFOS WHERE (SKILL_1='PYTHON') OR (SKILL_2='PYTHON') OR (SKILL_3='PYTHON') ORDER BY ID ASC;
     

    다른 사람들이 작성한 정답

    SELECT ID, EMAIL, FIRST_NAME, LAST_NAME FROM DEVELOPER_INFOS WHERE 'Python' IN (SKILL_1, SKILL_2, SKILL_3) ORDER BY ID
     
    💡
    레코드 in (컬럼1, 컬럼2, 컬럼3) → ORACLE DB에서는 사용불가능
     
    Share article

    silver

    RSS·Powered by Inblog