[Hackkerank] Weather Observation Station 9


[Hackkerank] Weather Observation Station 9

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 not (city like 'A%' or city like 'E%' or city like 'I%' or city like 'O%' or city like 'U%'); 모음으로 시작하지 않는 문자를 뽑아야하기에 위와 같이 select distinct city from station where regexp_like(city,'^[^AEIOU]'); 정규표현식을 쓰면 더 간단히 가능하다....

[Hackkerank] Weather Observation Station 9에 대한 요약내용입니다.

자세한 내용은 아래에 원문링크를 확인해주시기 바랍니다.


#hacckerrank #oracle #sql

원문링크 : [Hackkerank] Weather Observation Station 9