BlakeBrown/HackerRank-Solutions

Weather Observation Station 5-MySQL not working

sree-hari-s opened this issue · 1 comments

sree-hari-s commented

Code provided only works on db2 not on mysql

rohit465 commented

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;

Check for this,
This works for me.