/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

11 votes123 views3 answers
Python sqlite3 create table if not exists
SQL
21 votes126 views4 answers
Oracle add column
SQL
0 vote116 views1 answer
Apex for oracle 11g
SQL
1 vote118 views1 answer
Access the postgres psql
SQL
3 votes115 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote125 views1 answer
Changing name of column and datatype in sql
SQL
0 vote108 views1 answer
Sql sum if
SQL
13 votes106 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
7 votes243 views2 answers
Drop index oracle
SQL
0 vote117 views1 answer
Low level operator in dbms
SQL

Share