Friday, October 13, 2017

Get The City Name from Station table city name do not start with vowel and do not end with vowel

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 .

No comments:

Post a Comment

Featured Post

What is JavaScript? What is the role of JavaScript engine?

  The JavaScript is a Programming language that is used for converting static web pages to interactive and dynamic web pages. A JavaScript e...