/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 vote267 views1 answer
Print orcale
SQL
0 vote271 views1 answer
Sql server remove 0 from left
SQL
3 votes276 views3 answers
Update join
SQL
0 vote286 views1 answer
Arithmetic expression in sql
SQL
-1 vote234 views1 answer
How to create script to connect to oracle database and run query
SQL
12 votes290 views3 answers
Install sqlite driver ubuntu
SQL
0 vote295 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote287 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote328 views1 answer
Mysql get nth highest
SQL
1 vote260 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL

Share