/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 vote167 views1 answer
Dump only data
SQL
0 vote166 views1 answer
Mysql export search results
SQL
0 vote187 views1 answer
Mysql sleep connections
SQL
3 votes173 views1 answer
Sql cast to integer
SQL
0 vote193 views1 answer
Oracle list dblink
SQL
-1 vote158 views1 answer
How to use update trigger in sql
SQL
2 votes172 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote190 views1 answer
Insert value in identity
SQL
0 vote179 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
11 votes263 views2 answers
Sql between date range
SQL

Share