/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 vote125 views1 answer
Mysql bash execute sql file
SQL
0 vote125 views1 answer
Addition of 2 column value in mysql
SQL
0 vote129 views1 answer
Laravel eloquent get generated sql
SQL
2 votes162 views1 answer
How to select from mssql
SQL
2 votes134 views1 answer
Mysql change data type of column
SQL
0 vote113 views2 answers
Select limit ms sql
SQL
1 vote132 views1 answer
Sql count value greater than
SQL
9 votes116 views2 answers
Get first 3 letters in sql
SQL
0 vote126 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote78 views1 answer
Mysql convert column to uppercase
SQL

Share