/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 vote205 views1 answer
Sql quary stuf
SQL
0 vote176 views1 answer
Reona
SQL
3 votes181 views1 answer
Define REGEXP?
SQL
0 vote186 views1 answer
Write a query to peint the pattern P(20)
SQL
2 votes167 views1 answer
How to select first row of database sql
SQL
0 vote161 views1 answer
Pl sql search saurce code
SQL
7 votes168 views1 answer
Safe update mysql
SQL
0 vote170 views1 answer
Oracle array
SQL
1 vote176 views2 answers
Insert sqlite
SQL
2 votes169 views4 answers
How to find 2nd highest salary in mysql
SQL

Share