Menu
QWERTY: Designed to slow typists down.
Home
Hot
Random
Search
Browse
AI
AWS
Agile
Algorithms
Android
Apple
Azure
Backend
Bash
C++
Cloud
All Categories
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
10 months ago
624.9K views
0 shares
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
10 months ago
344.9K views
0 shares
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
Windows User And Linux User
Linux
121.2M views
19 days ago
is it so?
Programming
84.7K views
3 years ago
JYLH JOYSEEKER 42" Standing Desk Converter, Quick Sit to Stand Desk Riser
Affiliate
$179.99