목록2025/07/13 (1)
working_helen
[코테 연습] HackerRank 코딩테스트 연습 Medium & Hard
HackerRank 코딩테스트 연습 Medium & HardOccupations : pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output should consist of four columns (Doctor, Professor, Singer, and Actor) in that specific order, with their respective names listed alphabetically under each column. 풀이 1 > PIVOT 함수SELECT *FROM 테이블명PIVO..
외부 수업/SQL 스터디
2025. 7. 13. 17:04