/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

1 vote115 views2 answers
Oracle list partitioned tables
SQL
1 vote112 views1 answer
Postgresql update auto_increment value
SQL
0 vote107 views1 answer
View t-sql mail configuration
SQL
0 vote108 views1 answer
Drop tables from local database postgres pgadmin
SQL
1 vote102 views1 answer
Mysql batch insert
SQL
0 vote98 views4 answers
Mysql count table rows
SQL
0 vote159 views1 answer
Selecting specific day in colum sql
SQL
0 vote100 views1 answer
In mysql workbench contnent not feching
SQL
5 votes114 views2 answers
Mysql import gzip db
SQL
1 vote100 views1 answer
Oracle finding duplicate records
SQL

Share