/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

9 votes141 views4 answers
Add primary key to existing table sql
SQL
3 votes143 views1 answer
Créer une table sql
SQL
0 vote147 views1 answer
How to check xampp mysql password
SQL
7 votes162 views2 answers
Postgres concat
SQL
0 vote150 views1 answer
Update one column from another column in same table
SQL
1 vote145 views2 answers
Replace text in sql
SQL
11 votes147 views1 answer
Sql query to find duplicates in column
SQL
1 vote151 views5 answers
Postgresql difference between two dates in days
SQL
9 votes161 views4 answers
Last mysql
SQL
0 vote163 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL

Share