공부
-
[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%'
-
[HackerRank/Basic Select] Weather Observation Station 5공부/PS ( SQL) 2022. 5. 15. 23:11
https://www.hackerrank.com/challenges/weather-observation-station-5/problem Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com 문제 풀이 SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY LIMIT 1; SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ..