sql 코딩테스트

Database

[MySQL]SQL 코딩 테스트 대비 문법 정리

1. HackerRank - Basic select -- #6 SELECT DISTINCT CITY FROM STATION WHERE ID%2 = 0 -- #7 SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FROM STATION -- #8 SELECT MIN(LENGTH(CITY)) AND MAX(LENGTH(CITY)) FROM STATION ORDER BY DESC -- #11 SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) IN ('a', 'e', 'i', 'o', 'u') -- #12 SELECT DISTINCT(CITY) FROM STATION WHERE (RIGHT(CITY, 1) IN ('a', 'e', 'i'..

박한결
'sql 코딩테스트' 태그의 글 목록