/SQL/Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^aeiou].*[^aeiou]$';

0

Source: nifannn.github.io

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

select distinct city from station where city not regexp '^[aeiou]' or city not regexp '[aeiou]$';

0

Similar codes

3 votes215 views1 answer
Sql multi column index performance
SQL
18 votes207 views6 answers
Creating table in MySQL
SQL
0 vote233 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
-1 vote196 views1 answer
Module operator in oracle sql
SQL
0 vote209 views1 answer
Returning with sqlalchemy
SQL
2 votes187 views3 answers
Mysql cheat sheet
SQL
0 vote211 views1 answer
How to create a new shema using query languaage
SQL
0 vote203 views1 answer
Mysql Error Code: 1005
SQL
0 vote191 views1 answer
Generate random & unique mysql string
SQL
0 vote210 views1 answer
Mysql 8 geo to json
SQL

Share