/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

0 vote215 views8 answers
Convert sql query to linq online
SQL
0 vote358 views2 answers
Create fulltext index mysql
SQL
0 vote193 views1 answer
Set a value by excuting stored procedure
SQL
3 votes193 views4 answers
Ubuntu stop mysql
SQL
0 vote283 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote199 views2 answers
Sql having multiple conditions
SQL
10 votes281 views1 answer
Oracle all_dependencies
SQL
1 vote210 views2 answers
Group_concat limit mysql
SQL
0 vote193 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote216 views2 answers
Faster mysql imports
SQL

Share