Скачать или смотреть Q12 - City ending with Vowels | REGEXP_LIKE in SQL | Regular Expression SQL |

This video is based upon the concept of SQL and a part of SQL Practice Series.
If you enjoyed the video Please Like, Share & Subscribe.
#sql #select #regexp #regexp_in_sql #distinct #substr_in_sql #Regular_Expression_in_SQL #distinct_in_sql #sqlpractice #hackerrank #oraclesql

Question
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

Answer
1. select distinct(City) from Station where REGEXP_LIKE(City,'[aeiou]$');
2. select distinct(City) from Station where substr(City,-1,1) in ('a','e','i','o','u');
3. 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';


Credit:
This video features problems sourced from HackerRank. All rights to the original problems and platform belong to HackerRank. This content is created for educational purposes to help learners understand, solve and practice challenges.
https://www.hackerrank.com


DISCLAIMER :
Video is for educational purpose only. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.