/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

17 votes110 views4 answers
Postgres list users
SQL
2 votes106 views2 answers
Spring where to put the data sql
SQL
0 vote103 views1 answer
Postgres jsonb array push new element
SQL
2 votes106 views1 answer
Oracle sql merge
SQL
0 vote124 views1 answer
How convert into in in sql query
SQL
12 votes146 views4 answers
How to drop all tables in postgresql
SQL
32 votes107 views6 answers
Sql count where
SQL
1 vote109 views1 answer
Partition by sql server
SQL
0 vote102 views1 answer
What does leave do in mysql
SQL
0 vote66 views1 answer
Como leer datos de mysql esp32
SQL

Share