You are viewing a single comment's thread. Return to all comments →
Please tell me , what is wrong in my query.
1)SELECT distinct name FROM emp WHERE REGEXP_LIKE(name, '^[^AaEeIiOoUu].*[^AaEeIiOoUu]$');
2)SELECT DISTINCT name FROM emp WHERE LOWER(SUBSTR(name,1,1)) not IN ('a','e','i','o','u') AND LOWER(SUBSTR(name,-1,1)) not IN ('a','e','i','o','u');
Both are showing correct output in my local.But,it showed wrong answer as here. Anyone please explain to me.
Note : Here ,
CITY = NAME STATION = EMP.
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 11
You are viewing a single comment's thread. Return to all comments →
Please tell me , what is wrong in my query.
1)SELECT distinct name FROM emp WHERE REGEXP_LIKE(name, '^[^AaEeIiOoUu].*[^AaEeIiOoUu]$');
2)SELECT DISTINCT name FROM emp WHERE LOWER(SUBSTR(name,1,1)) not IN ('a','e','i','o','u') AND LOWER(SUBSTR(name,-1,1)) not IN ('a','e','i','o','u');
Both are showing correct output in my local.But,it showed wrong answer as here. Anyone please explain to me.
Note : Here ,
CITY = NAME STATION = EMP.