/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 votes266 views2 answers
Sql conn
SQL
0 vote272 views1 answer
Sql select random procentage from rows
SQL
0 vote253 views1 answer
Get server date mysql
SQL
0 vote273 views1 answer
QUERY JPQL
SQL
1 vote275 views1 answer
Date_part mysql
SQL
0 vote283 views1 answer
Write SQL in ruby on rails
SQL
49 votes341 views6 answers
Install mysql ubuntu
SQL
0 vote270 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote294 views3 answers
Read all columns of a table sql
SQL
10 votes274 views6 answers
Sql between
SQL

Share