Order by Memes

Posts tagged with Order by

Clock But It's SELECT DIGITS FROM NUMBERS ORDER BY DIGIT NAME DESC

Databases Programming

3 hours ago 51.1K views 0 shares

Clock But It's SELECT DIGITS FROM NUMBERS ORDER BY DIGIT NAME DESC

OH. MY. GOD. This is what happens when you let a database admin design a clock! The numbers are in complete chaos because some SQL-obsessed maniac decided to ORDER BY DIGIT NAME DESC instead of, you know, ACTUAL NUMERICAL ORDER like a SANE HUMAN BEING! The SQL query literally sorted the digits by their spelled-out names in descending order, so "twelve" comes before "three" which comes before "ten" and so on. Can you imagine trying to tell time on this monstrosity?! It's like asking what time it is and getting back "SELECT CURRENT_TIME FROM REALITY WHERE SANITY = NULL"!