Viewing 15 posts - 151 through 165 (of 703 total)
Anipaul (6/22/2011)
As Mike said the question would have been little tricky if one or two rows contains null. As we know except for COUNT, aggregate functions ignore null values.
COUNT behaves...
June 22, 2011 at 12:04 pm
$450MM coincidentally is probably about what the debt is for the Dodgers. Forbes magazine put the team's value at number three in baseball this past March at $800MM.
http://www.forbes.com/lists/2011/33/baseball-valuations-11_Los-Angeles-Dodgers_338671.html
June 21, 2011 at 11:51 am
webrunner (5/24/2011)
May 24, 2011 at 9:33 am
Ray K (5/13/2011)
Sad piece of news. Best wishes, Mr. Killebrew, as you enter the twilight of your life.
Sad news, indeed. As a Giants fan,...
May 16, 2011 at 12:49 pm
Toreador (5/10/2011)What use is there for reseeding in real-world applications?
BOL gives the example of a counter reaching the limit for a column (e.g. over 2.147 billion for an integer). RESEED...
May 10, 2011 at 10:01 am
Not as easy for some ouf us as it looks. The real "gotcha" here is that the RESEED option sets the current value of the column's internal counter while...
May 10, 2011 at 9:25 am
GilaMonster (5/9/2011)
Oh my: http://shitmystudentswrite.tumblr.com/
Thanks, Gail. The one labeled "Hot Potato" struck me as a great example of the inter-connectedness of ignorance and bigotry.
May 9, 2011 at 4:54 pm
It's good to see my Giants wake up this weekend. Looks to me as though the NL West is a two-horse race (SF and Colorado), and no, Steve, I...
May 9, 2011 at 12:10 pm
Jon Carroll writes a daily column in the San Francisco Chronicle. Yesterday's screed was about "help vampires". Denizens of the Thread will certainly recognize the symptoms. http://www.sfgate.com/cgi-bin/article.cgi?f=/c/a/2011/05/04/DD3J1JB96L.DTL
May 6, 2011 at 5:56 pm
Good question today. It may be a future QOD, and if so, here's a hint. The first option (the last time for which you have useable data) is the...
May 3, 2011 at 7:06 pm
Yes, this was easy to answer. But I suspect that among all those who answered correctly, there would be a good percentage who may not follow the stated practices,...
April 21, 2011 at 11:07 am
Ironically, it's when I noticed the question was worth 7 points that I remembered the date. Got it right then, of course, but "Prime grandchild" is such an appealing...
April 1, 2011 at 9:35 am
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
ROFL!!!! Are you sure it wasn't April first when you got...
March 30, 2011 at 7:13 pm
Kiara (3/29/2011)
I just spent about 45 minutes writing out a...
March 30, 2011 at 7:07 pm
Fogarty's voice in my mind....
Well, a-beat the drum and hold the phone
The sun came out today
We're born again, there's new grass on the field
A-roundin' third and headed for home
It's a...
March 30, 2011 at 11:20 am
Viewing 15 posts - 151 through 165 (of 703 total)