/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

1 vote283 views1 answer
How do you use sql in you company
SQL
2 votes288 views1 answer
Find all triggers in database
SQL
5 votes296 views2 answers
Get number of columns sql
SQL
0 vote282 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
7 votes306 views1 answer
Oracle alter sequence restart start with
SQL
9 votes283 views4 answers
Last mysql
SQL
2 votes316 views3 answers
How to check current user in mySQL
SQL
1 vote275 views4 answers
Between vs in sql
SQL
0 vote283 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote272 views2 answers
Mysql does sentance contain word
SQL

Share