My programing World
A collection of programs and interview questions
Saturday, June 4, 2016
SQL vowel at beginning and end
select distinct city
from station
where lower(substr(city,1,1)) in ('a','e','i','o','u') and
( lower(city) like ('%a') or
lower(city) like ('%e') or
lower(city) like ('%i') or
lower(city) like ('%o') or
lower(city) like ('%u'));
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment