Hackerrank - Weather Observation Station 5

Popis problému
Celý popis zadania sa nacháza – Hackerrank.

Riešenie

Vytvoril som riešenie v týchto programovacích jazykoch:

Všetky riešenia sú dostupné aj na mojom GitHub profile.

SQL

select * from
( 
    select city, length(city)
    from station
    order by length(city) asc, city asc
)
where rownum = 1
union 
select * from
( 
    select city, length(city)
    from station
    order by length(city) desc, city asc
)
where rownum = 1;

select * from

(

select city, length(city)

from station

order by length(city) asc, city asc

)

where rownum = 1

union

select * from

(

select city, length(city)

from station

order by length(city) desc, city asc

)

where rownum = 1;

Pavol Pidanič

Dokážem na 10 prstoch napočítať do 1023

Hackerrank – Weather Observation Station 5