/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 vote130 views1 answer
User defined variables in sql
SQL
0 vote232 views4 answers
Stored procedure sql
SQL
0 vote140 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote167 views1 answer
Cannot start database server xampp mac os
SQL
1 vote137 views1 answer
How to update date add hours in postgresql
SQL
1 vote134 views1 answer
Mamp mysql path mac
SQL
1 vote145 views1 answer
Decalre temp table sql
SQL
6 votes141 views1 answer
Oracle trigger after logon on schema
SQL
0 vote143 views1 answer
Download sql file of countries names
SQL
16 votes137 views4 answers
Ascending order mysql
SQL

Share