We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Weather Observation Station 10
  5. Discussions

Weather Observation Station 10

Sort 234 Discussions, By:

votes

  • sakshamkumarsak1 + 2 comments

    SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) NOT IN ('a','e','i','o','u');

    WHATS wrong in this?

    • akgnit + 0 comments

      oracle won't recognize RIGHT . choose mysql .It will work perfectly

    • 26shweta_s + 0 comments

      put NOT before RIGHT i.e. SELECT DISTINCT CITY FROM STATION WHERE NOT RIGHT(CITY,1) IN ('a','e','i','o','u');

  • pralabhsaxena05 + 3 comments

    select DISTINCT city from STATION where city NOT REGEXP '[aeiou]$'

    • gaoning_ust + 1 comment

      It does not work

      • pralabhsaxena05 + 0 comments

        try again ..it will

    • vaibhav31595 + 1 comment

      thanks bro I was searching this query....

      • pralabhsaxena05 + 0 comments

        ur wlcm :)

    • achson + 1 comment

      SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[^aiueo]$';

      I used this work perfectly. You should remove NOT before REGEXP.

      • pralabhsaxena05 + 0 comments

        both are same and work perfectly !

  • alissonsouje + 2 comments

    select distinct city from station where city REGEXP '[^AEIOU]$'; This should perfectly work guys, in MySQL

    • achson + 1 comment

      SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[^aiueo]$';

      This one work perfectly. You should lower string of vowels.

      • khushbooneole + 0 comments

        regexp_like (city , '[aeiou]$ , 'i')) i is for insensetive case c is for case sensative

    • ashwinidotx + 1 comment

      what does the $ symbol denote ?

      • alissonsouje + 0 comments

        It specifies that character is at the end of the word

  • lance_norskog + 1 comment

    There is a certain sameness to this series of challenges. I'm doing these as exercises. By this time I'm not learning anything new...

    • benn_lynch_04 + 2 comments

      I was just about to comment the same thing.

      • bdchambers79 + 0 comments

        Have you ever studied math, and been given a set of 100+ problems to solve, all doing the same thing?

        There's a purpose to it.

      • rgulshan + 0 comments

        Select distinct city from station where city not regexp '^[...aeiou]';

  • aaronlopezsosa + 1 comment

    --MYSQL-- select distinct city from station where city not rlike '[aeiou]$';

    • b_kunila + 0 comments

      FOR MYSQL: SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[^AEIOU^]$'

  • abhilash_psp + 1 comment

    Oracle:

    select distinct CITY from STATION where lower(substr(city,length(city),1)) not in ('a','e','i','o','u');

    its working Fine

    • ahtirma + 2 comments

      can you please explain why 1 is used?

      • yogicode1 + 0 comments

        to select only one letter i.e., extracting last letter. instead of using length(city), we can use -1 as well which scans from backwards

      • BansheeGhoul + 0 comments

        to get one character only

  • Faker88Si + 0 comments

    MYSQL

    SELECT DISTINCT CITY
  FROM STATION
 WHERE CITY RLIKE '[^aeiou]$';

  • arpitt_94 + 0 comments

    select distinct city from STATION where right(CITY,1) NOT IN ('a','e','i','o','u') ;

    it worked with distinct in My SQL but failed without distinct . What is wrong if we don't use distinct?

  • _clfm_ + 0 comments

    MySQL - clean & correct

    Let me know if you have any questions!

    SELECT DISTINCT CITY
  FROM STATION
 WHERE CITY REGEXP '[^aeiou]$';

    (From my HackerRank repo on GitHub.)

  • mobi5592 + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '[^aeiou]$';

Load more conversations