/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 vote352 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
16 votes377 views1 answer
Mssql int max value
SQL
0 vote338 views1 answer
Get who is hired in january in sql
SQL
0 vote424 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
9 votes366 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote353 views1 answer
Login failed for login due to trigger execution
SQL
0 vote397 views1 answer
Combine 2 columns search query mysql
SQL
-1 vote334 views2 answers
Full join sql
SQL
8 votes348 views1 answer
Oracle all_source package body
SQL
0 vote351 views1 answer
Create date sql
SQL

Share