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 199 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');

  • 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

  • rayedox + 0 comments

    Solution of the given problem in Microsoft Sql Server by Rayedox Technologies :

    select distinct(city) from station where substring(city,len(city),2) not in ('a','e','i','o','u')

    Please visit www.rayedox.com for futher queries or mail us at support@rayedox.com or rayedox@gmail.com

  • pralabhsaxena05 + 0 comments

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

  • sagarjnv24 + 0 comments

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

  • sprasad566 + 0 comments

    works for Oracle : select distinct city from station where not regexp_like(city,'[aeiou]$');

  • tusharshrinkhal1 + 1 comment

    oracle

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

    • sugandh_kverma + 0 comments

      hi, this worked for me, but i tried the same code myself it did not work the 1st time. Does the space between city, -1 and 1 matter?

  • jayp1193 + 0 comments

    For MS SQL Server: Select distinct CITY from STATION where not CITY like '%[aeiou]';

Load more conversations