/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 vote258 views1 answer
Postgresql if 0 then 1
SQL
0 vote241 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote259 views1 answer
View t-sql mail configuration
SQL
4 votes187 views1 answer
And or sql order of operations
SQL
0 vote283 views1 answer
Mysql streaming example
SQL
2 votes234 views4 answers
Sql query interview questions
SQL
0 vote264 views1 answer
Sql date time query find
SQL
0 vote266 views1 answer
Netstat -tln mysql
SQL
17 votes266 views4 answers
Show tables sql server
SQL
13 votes230 views4 answers
Mysql get last row
SQL

Share