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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 5
  5. Discussions

Weather Observation Station 5

Sort by

recency

|

7071 Discussions

|

  • pragyanprabha_p1
     + 0 comments

    In Oracle SQL Developer m writing with below query but it's not working. Can someone please help! WITH MAXCITY AS (SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY)=(SELECT MAX(LENGTH(CITY)) FROM STATION) ORDER BY CITY DESC FETCH FIRST 1 ROW ONLY ), MINCITY AS (SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY)=(SELECT MIN(LENGTH(CITY)) FROM STATION) ORDER BY CITY DESC FETCH FIRST 1 ROW ONLY ) SELECT CITY AS CITY,LENGTH(CITY) AS CITYLENGTH FROM MAXCITY UNION SELECT CITY AS CITY,LENGTH(CITY) AS CITYLENGTH FROM MINCITY;

  • karanpal0010
     + 0 comments

    select CITY,length(CITY) from STATION where CITY like 'a%' order by length(CITY) limit 1; select CITY,length(CITY) from STATION order by length(CITY) desc limit 1;

  • vrgr82020
     + 0 comments

    select CITY,LENGTH(CITY) from STATION ORDER BY LENGTH(CITY) DESC,CITY LIMIT 1; select CITY,LENGTH(CITY) from STATION ORDER BY LENGTH(CITY),CITY LIMIT 1;

  • trinhminhhieu003
     + 0 comments

    MySQL:

    WITH LENGTH_CITY as ( SELECT CITY, LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) IN ( SELECT MAX(LENGTH(CITY)) FROM STATION UNION SELECT MIN(LENGTH(CITY)) FROM STATION ) )

    SELECT CITY, LENGTH(CITY) FROM LENGTH_CITY ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 2;

    SELECT CITY, LENGTH(CITY) FROM LENGTH_CITY ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 2;

  • henriquelopes
     + 0 comments
    (select city, length(city) from station order by length(city) asc, city asc limit 1) 
union
(select city, length(city) from station order by length(city) desc, city asc limit 1);