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

|

6547 Discussions

|

  • karolkojro
     + 0 comments

    -- T-SQL

    select city, len (city) as dlugosc from station where city in (select top(1) city from station order by len(city) desc, city) or city in (select top(1) city from station order by len(city) asc, city)

  • jabirjoyed99
     + 0 comments

    //Correct Answer

    ( SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1 )

    UNION ALL

    ( SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1 );

  • jabirjoyed99
     + 0 comments

    //Correct Answer

    ( SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1 ) UNION ALL ( SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1 );

  • deshpanderaza
     + 0 comments

    **SIMPLE LOGIC **`

    (
SELECT CITY, LENGTH(CITY)
FROM STATION 
ORDER BY LENGTH(CITY), CITY LIMIT 1
)
UNION ALL
(
SELECT CITY, LENGTH(CITY)
FROM STATION 
ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1

)

    `

  • deshpanderaza
     + 0 comments

    **SIMPLE LOGIC **`

    (
SELECT CITY, LENGTH(CITY)
FROM STATION 
ORDER BY LENGTH(CITY), CITY LIMIT 1
)
UNION ALL
(
SELECT CITY, LENGTH(CITY)
FROM STATION 
ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1




)

    `