공부/PS ( SQL)
-
[HackerRank/Basic Select] Weather Observation Station 12공부/PS ( SQL) 2022. 5. 16. 00:16
https://www.hackerrank.com/challenges/weather-observation-station-12/problem Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com 문제 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[^aeiou]" AND CITY REGEXP "[^aeiou]$"
-
[HackerRank/Basic Select] Weather Observation Station 11공부/PS ( SQL) 2022. 5. 16. 00:13
https://www.hackerrank.com/challenges/weather-observation-station-11/problem Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com 문제 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[^aeiou]" OR CITY REGEXP "[^aeiou]$"
-
[HackerRank/Basic Select] Weather Observation Station 9공부/PS ( SQL) 2022. 5. 16. 00:02
https://www.hackerrank.com/challenges/weather-observation-station-9/problem Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com 문제 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[^aeiou]" 정규표현식으로 ^[^aeiou] 를 사용하여 a,e,i,o,u로 시작하지 않는 값들을 찾아주었다.
-
MYSQL 정규표현식공부/PS ( SQL) 2022. 5. 15. 23:56
https://velog.io/@gillog/MySQL-REGEXPRegular-Expression%EC%A0%95%EA%B7%9C-%ED%91%9C%ED%98%84%EC%8B%9D [MySQL] REGEXP(Regular Expression(정규 표현식)) REGEXP는 LIKE를 이용한 검색과 달리 Regular Expression(정규 표현식)를 이용해 검색한다.REGEXP를 사용하면 SQL에서 정규표현식을 활용하여 기본 연산자보다 복잡한 문자열 조건을 걸어 데이터를 검색할 velog.io
-
[HackerRank/Basic Select] Weather Observation Station 8공부/PS ( SQL) 2022. 5. 15. 23:55
https://www.hackerrank.com/challenges/weather-observation-station-8/problem Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com 문제 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[aeiou]" AND CITY REGEXP "[aeiou]$" 정규표현식 사용 컬럼명 REGEXP "^[시작할 문자열]" AND 컬럼명 REGEXP "[끝나는 문자열]$"
-
[HackerRank/Basic Select] Weather Observation Station 7공부/PS ( SQL) 2022. 5. 15. 23:21
https://www.hackerrank.com/challenges/weather-observation-station-7/problem Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com 문제 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u'
-
[HackerRank/Basic Select] Weather Observation Station 6공부/PS ( SQL) 2022. 5. 15. 23:18
https://www.hackerrank.com/challenges/weather-observation-station-6/problem Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com 문제 풀이 SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'a%' OR CITY LIKE 'e%' OR CITY LIKE 'i%' OR CITY LIKE 'o%' OR CITY LIKE 'u%'