Get The City Name from Station table city name do not start with vowel and do not end with vowel and city name not repeat
Select distinct city from station where city NOT RLIKE '^[aeiouAEIOU].*[aeiouAEIOU]$'
The above query give the city name whose do not start with vowel and do not end with vowel .
Select distinct city from station where city NOT RLIKE '^[aeiouAEIOU].*[aeiouAEIOU]$'
The above query give the city name whose do not start with vowel and do not end with vowel .
No comments:
Post a Comment