/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 vote147 views1 answer
Postgres check blocking
SQL
0 vote176 views3 answers
Mysql keyword search
SQL
1 vote200 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote115 views1 answer
Raven ql select count
SQL
7 votes250 views2 answers
Sql empty table
SQL
0 vote156 views1 answer
Postgresql get diff between two dates in Months
SQL
2 votes163 views1 answer
Capitalize 1st letter in sql server
SQL
1 vote180 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote172 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote159 views1 answer
Sql character index
SQL

Share