/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

24 votes280 views4 answers
Mssql get all table names
SQL
0 vote298 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote419 views1 answer
Sql developer export connections
SQL
10 votes245 views1 answer
Oracle view dependencies
SQL
20 votes302 views5 answers
Sql show tables
SQL
3 votes291 views3 answers
How to add month in update sql
SQL
0 vote288 views1 answer
Update sqlite
SQL
5 votes293 views4 answers
Rollback to in sql
SQL
0 vote306 views1 answer
How to add session data into mysql database from button
SQL
18 votes297 views3 answers
Mysql add column with default value
SQL

Share