Logo
The @ symbol was chosen for email in 1971.
  • Home
  • Hot
  • Random
  • Search

Browse

  • AI AI
  • AWS AWS
  • Agile Agile
  • Algorithms Algorithms
  • Android Android
  • Apple Apple
  • Azure Azure
  • Backend Backend
  • Bash Bash
  • C++ C++
  • Cloud Cloud
  • All Categories
As an Amazon Associate ProgrammerHumor.io earns from qualifying purchases.

HTTP 418: I'm a teapot

The server identifies as a teapot now and is on a tea break, brb

HTTP 418: I'm a teapot

The server identifies as a teapot now and is on a tea break, brb

Order by Memes

Posts tagged with Order by

SQL Time Is Always Wrong Time

Databases Programming Debugging
11 months ago 644.5K views 0 shares
SQL Time Is Always Wrong Time
What happens when a DBA designs a clock? You get Roman numerals in completely random order because SQL queries without proper constraints do whatever they want. Notice how IX (9) is where 4 should be, and V (5) is at 6 o'clock. The comment "It Will Work This Time" is the eternal lie every developer tells themselves before running untested SQL in production. Spoiler: it never does.

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

Databases Programming
11 months ago 354.2K 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"!

Today's picks

UPLIFT DESK Dark Bamboo (72 x 30 inch) Standing Desk 2-Leg V3 Adjustable Stand Up C-Frame (Indus.), Advanced Keypad, Wire Grommets, Wire Tray, Rocker Board

UPLIFT DESK Dark Bamboo (72 x 30 inch) Standing Desk 2-Leg V3 Adjustable Stand Up C-Frame (Indus.), Advanced Keypad, Wire Grommets, Wire Tray, Rocker Board

Affiliate
$988.00
How To Become A Software Engineer Without Learning How To Code

How To Become A Software Engineer Without Learning How To Code

AI
533.7K views 6 months ago
Biggest lie

Biggest lie

Programming
123.1K views 5 years ago