Four Gables Guy: Save this SQL query

Thursday, November 20, 2008

The following query took 28 years to return.


SELECT firstname
FROM all_humanity
WHERE
gender = 'female'
ORDER BY beauty, wisdom


Query returned 53,228,183,834 rows
Rebecca
Mary
Eve
...

But the wait was worth it because I married the first row returned.

Hillary said...: NEEEEERRRRRRDDDDD!!! But I guess I am a nerd too because I could read your code. Randy says 0000001 (nerd); November 20, 2008 at 8:26 PM
Christina said...: You're cute, and a sweet talker.; November 21, 2008 at 7:34 AM
Chris said...: Your order by clause is wrong, it should be:

ORDER BY beauty DESC, wisdom DESC

Yikes, better change that quick before Rebecca learns SQL. Sorry I guess I'm a blog stalker now, somehow I found your blog. By the way, I think you are a great person, because you can do hard things and not complain. Have a Merry Christmas!; December 13, 2011 at 3:33 PM

Four Gables Guy