/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

21 votes227 views6 answers
Update sql
SQL
0 vote219 views1 answer
How change the field place in mysql
SQL
0 vote221 views1 answer
Postgresql comandos basicos
SQL
0 vote230 views4 answers
What is unique key in sql
SQL
0 vote217 views1 answer
Modificar tipo de dato sql server
SQL
0 vote206 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote216 views2 answers
Mysql on update current_timestamp
SQL
1 vote231 views1 answer
Table valued functions in sql
SQL
1 vote201 views1 answer
Psql show with user is logged in
SQL
5 votes270 views2 answers
How to ascending order in sql
SQL

Share