Weather Observation Station 5

  • + 2 comments

    Because 'ORDER BY' function now has two parameters which are:

    • '2' - And will first order the results by this one
    • '1 DESC' - So if there are results with equal 'LENGTH(city)' after the first ordering it will order these (the equal length ones) by REVERSE alphabetical order.

    *Note: The DESC only applies to the 1 argument/parameter in front of it NOT to all of them;

    Further note: I am not a pro with MySQL but I've tested this a bit and this is what I noticed;