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 5
  5. Discussions

Weather Observation Station 5

  • virenderkumar + 1 comment

    this is not a right query or syntex. please do read about syntex of "ORDER BY" and also on "HAVING" clause.

    • adam_allard + 1 comment

      the syntax for ORDER BY is correct. If I run the exact same query without the FETCH clause then the query works just fine.

      Going off these docs, my query with FETCH should work just fine. https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1

      • virenderkumar + 3 comments

        Try this in "oracle" envoirment:

        select city,length_city from (select a.*, rownum r from (select length(city) length_city,city from station order by length_city, city) a) where r in (1,(select count(*) from station))

        • adam_allard + 0 comments

          Yes I'm using Oracle DB, as my original post stated.

          Thank you for your answer, but I am wondering why Oracle's FETCH clause is not working here...

        • faiza_fiz2015 + 0 comments

          Can you explain this query?

        • aravind_bijjala1 + 0 comments

          if there are more cities with length 21 this doesnt work