/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

5 votes215 views4 answers
Describe table postgres
SQL
0 vote231 views1 answer
Mariadb date equals to current_date plus days
SQL
2 votes247 views1 answer
Sql server find columns list in tables
SQL
2 votes224 views1 answer
Sql server find table name
SQL
0 vote214 views1 answer
How to get all values in a table mysql in c#
SQL
23 votes227 views6 answers
Delete all rows from table sql
SQL
0 vote256 views2 answers
Temp Space
SQL
0 vote236 views1 answer
Sql server list user permissions
SQL
1 vote245 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote244 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL

Share