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

|

7097 Discussions

|

  • andresvilla1000
     + 0 comments

    SELECT TOP 1 CITY, LEN (CITY) FROM STATION WHERE LEN(CITY) = ( SELECT MIN(LEN(CITY)) FROM STATION) ORDER BY CITY ASC

    SELECT TOP 1 CITY, LEN (CITY) FROM STATION WHERE LEN(CITY) = ( SELECT MAX(LEN(CITY)) FROM STATION) ORDER BY CITY ASC

  • lilaleo06
     + 0 comments

    I love how SQL lets you work with complex data sets in such a clean, readable way. betguru 247 net register

  • gizem34temel
     + 0 comments

    MYSQL

    select city, length(city) from station where length(city) in ( select min(length(city)) from station ) ORDER BY city asc limit 1; select city, length(city) from station where length(city) in ( select max(length(city)) from station ) ORDER BY city asc limit 1;

  • dfcalderong1992
     + 0 comments

    MySQL ----->

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

  • anirudhkasarla09
     + 0 comments

    In MS SQL Server

    select Top 1 city,len(city) as f from station ORDER BY f ASC , city ASC; select Top 1 city,len(city) as f from station ORDER BY f desc, city DESC;

    In DB2

    Select city,length(city) as name from station ORDER BY name, city asc fetch first 1 row only; Select city,length(city) as name from station ORDER BY name desc,city desc fetch first 1 row only;