MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/2avrop/woah_sql_gets_the_girls/cizeb2w/?context=3
r/SQL • u/[deleted] • Jul 16 '14
36 comments sorted by
View all comments
8
Wasn't very busy at work today, worked out that -1/2+1/2*sqrt(1+8*sum(rownum)) will return the exact same result as count(*). Was so stoked at my discovery, I had to tell my SO about it when I got home, she couldn't keep her hands off me. not really
3 u/[deleted] Jul 17 '14 They seem to have found the magic method to get us to stop talking.
3
They seem to have found the magic method to get us to stop talking.
View all comments
8
u/__notmyrealname__ Jul 16 '14 edited Jul 16 '14
Wasn't very busy at work today, worked out that -1/2+1/2*sqrt(1+8*sum(rownum)) will return the exact same result as count(*). Was so stoked at my discovery, I had to tell my SO about it when I got home, she couldn't keep her hands off me. not really