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

|

7163 Discussions

|

  • rodrigo_a_wong
     + 0 comments

    WITH ranking AS( SELECT CITY, ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) DESC, CITY) AS rnk_top, ROW_NUMBER() OVER (ORDER BY LENGTH(CITY)ASC, CITY) AS rnk_bottom FROM STATION )

    SELECT CITY, LENGTH(CITY) FROM ranking WHERE rnk_top = 1 UNION SELECT CITY, LENGTH(CITY) FROM ranking WHERE rnk_bottom = 1;

  • didzis_dti
     + 0 comments

    Any ideas wh the commnd UNION is not processed ? i got correct answer using this but it doesn't make sense without union as those would be treated as 2 seperate executions.

    SELECT TOP 1 CITY, LEN(CITY) AS LEN FROM STATION ORDER BY LEN(CITY) ASC, CITY ASC;

    SELECT TOP 1 CITY, LEN(CITY) AS LEN FROM STATION ORDER BY LEN(CITY) DESC, CITY ASC;

  • s_sharan5454
     + 0 comments
    SELECT CITY, name_length
FROM (
    SELECT 
        CITY,
        LENGTH(CITY) as name_length,
        ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) ASC, CITY ASC) as shortest_rank,
        ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) DESC, CITY ASC) as longest_rank
    FROM STATION
) ranked
WHERE shortest_rank = 1 OR longest_rank = 1;

  • s_sharan5454
     + 0 comments

    SELECT CITY, name_length FROM ( SELECT CITY, LENGTH(CITY) as name_length, ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) ASC, CITY ASC) as shortest_rank, ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) DESC, CITY ASC) as longest_rank FROM STATION ) ranked WHERE shortest_rank = 1 OR longest_rank = 1;

  • samuel2ayman
     + 0 comments
    SELECT CITY,LENGTH(CITY) FROM STATION 
ORDER BY LENGTH(CITY)ASC,CITY ASC
LIMIT 1;

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