/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 vote353 views1 answer
Query string starts with vowels
SQL
1 vote359 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote340 views1 answer
How to add timestamp column in mysql
SQL
1 vote544 views2 answers
Sql unique rows
SQL
0 vote351 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote344 views1 answer
Sql on-premises
SQL
0 vote353 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote327 views1 answer
Partitioning in oracle-base
SQL
0 vote343 views2 answers
Raise notice in postgresql function
SQL
3 votes333 views1 answer
Oracle get trigger ddl
SQL

Share