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 174 Discussions, By:

votes

  • rameshrv4 + 5 comments

    MySQL

    select distinct city from station where city regexp '[^aeiou]$'
    • SS
      saisandeep61 + 5 comments

      it is not woring

      • rameshrv4 + 1 comment

        dude it's perfectly working. seems you forgot to select MySQL. that regexp won't work in oracle type query

        • BG
          BansheeGhoul + 1 comment

          For oracle its simple ..

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

          • tkm0996 + 0 comments

            thanks dude.

      • B
        bonniegu0429 + 0 comments
        [deleted]
      • RT
        ragineetitar + 1 comment

        use this dear-

        SELECT DISTINCT CITY FROM STATION WHERE NOT (CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u');

        • rameshrv4 + 2 comments

          that's pretty much straight forward but what about A,E,I,O,U? in my query it will be 

          select distinct city from station where city regexp '[^aeiouAEIOU]$'

          try using regexp dear it will be more fun

          • MS
            shaabancis + 0 comments

            SQL server select disrinct city from station where city not like '%[aeiou]';

          • thy_anmol + 1 comment

            why using $ ? what exactly does regexp does ?

            • rameshrv4 + 0 comments

              $ is used to match the last character of a word(^ is for first char). regexp will do a regular expression matching. to learn more about usage of regexp in MySql just checkout this link https://www.w3resource.com/mysql/string-functions/mysql-regexp-function.php

      • OB
        Oseghr + 0 comments

        MySQL

        select distinct (city) from station where not (city like '%a' or city like '%e' or city like '%i' or city like '%o' or city like '%u');

      • ypcharan3 + 0 comments

        select distinct city from station where city not regexp '[aeiou]$';

    • bmdkumar74 + 1 comment

      can u tell y $ is used

      • rameshrv4 + 0 comments

        $ is used to match the last word or char in a string(regexp).checkout this page for further clarifications https://www.tutorialspoint.com/mysql/mysql-regexps.htm

    • kingshukchoudhu1 + 1 comment

      can you tell me how [^aeiou] works?

      • rameshrv4 + 2 comments

        [] this block used to execute each character from a given string. so [aeiou] will manipulate each char and match with the result string.^ is used for negation in MySQL. '[^aeiou]$' will match with the ending letter of a string and '^[^aeiou]' will match with the starting letter of a string. It is actually a special regex in ruby, MySQL. [abc] will search for a,b,c characters. [^abc] will do the exact opposite,it search for all characters except a,b,c.

        • kingshukchoudhu1 + 0 comments

          thanks

        • FZ
          fernandozavalet1 + 0 comments

          I failed so many times, since I thought for negative is ?! and not ^, It works now thanks a lot.

    • sidharth_kpa + 0 comments

      It is working :) select distinct CITY from STATION where CITY NOT REGEXP '.*[aeiou]$'

    • DS
      danivilela + 0 comments

      Oracle suggestion: SELECT distinct CITY FROM STATION WHERE NOT REGEXP_LIKE(city ,'(a|e|i|o|u)$');

  • marinskiy + 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT DISTINCT City
FROM Station
WHERE REGEXP_LIKE(City, '[^aeiou]$');

    Feel free to ask if you have any questions :)

  • SK
    sakshamkumarsak1 + 1 comment

    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

  • LN
    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]';

  • AL
    aaronlopezsosa + 1 comment

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

    • B
      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

    • A
      ahtirma + 2 comments

      can you please explain why 1 is used?

      • YT
        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

      • BG
        BansheeGhoul + 0 comments

        to get one character only

  • prabhat_saroha11 + 0 comments

    select distinct city from station where city not like '%a' and city not like '%e' and city not like '%i' and city not like '%o' and city not like '%u';

    in Oracle

  • UG
    udayan614 + 0 comments

    MYSQL

    select distinct city from station where city not like '%a' and city not like '%e' and city not like '%i' and city not like '%o' and city not like '%u';

  • AV
    avashishth56 + 0 comments

    MySQL

    SELECT DISTINCT CITY FROM STATION
WHERE RIGHT(CITY,1) NOT IN ('A','E','I','O','U')

  • DC
    chaudhury_dip + 0 comments

    select distinct city from station where substr (city,-1,1) not in ('a','e','i','o','u');

Load more conversations