/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

4 votes332 views2 answers
Error loading MySQLdb module.
SQL
1 vote396 views1 answer
Postgresql if 0 then 1
SQL
0 vote349 views1 answer
Enable full text search mysql
SQL
0 vote343 views1 answer
Mysql two joins
SQL
17 votes409 views4 answers
Show all tables in oracle
SQL
22 votes337 views4 answers
Tsql rename table
SQL
5 votes410 views1 answer
Mysql where one year ago
SQL
5 votes346 views1 answer
Postgresql functions
SQL
0 vote344 views1 answer
Sql waitfor
SQL
-1 vote368 views3 answers
My sql alter table
SQL

Share