Viewing 15 posts - 61 through 75 (of 450 total)
'For the DISTINCT keyword, null values are considered to be duplicates of each other. When DISTINCT is included in a SELECT statement, only one NULL is returned in the results,...
January 19, 2018 at 1:52 am
Had to have a stab in the dark.
Guess what - got it wrong.
January 16, 2018 at 8:45 am
Sounded like it must be the right answer.
Thanks Steve.
December 18, 2017 at 4:34 am
Well, having learnt SQL through Oracle in the '80s I originally thought this just couldn't be done, so I was surprised when I read BOL.
Certainly nonsensical though.
November 29, 2017 at 1:57 am
Took me some time to submit my answer as I was looking for a non-existent catch.
November 17, 2017 at 4:51 am
Knew it must one of the first two options, but got it wrong.
Learnt something though.
October 17, 2017 at 2:40 am
October 13, 2017 at 9:24 am
Steve Jones - SSC Editor - Friday, September 29, 2017 7:42 AMSorry, wrong box checked. Points awarded back and answer corrected
Good man!
September 29, 2017 at 8:21 am
I'm also part of the 91% who got this wrong.
Well done to the rest!
September 29, 2017 at 3:17 am
Subtle difference between third and fourth options caught me out.
September 27, 2017 at 1:21 am
Thanks for today's QOTD Steve.
Tricky question - just 29% correct so far.
September 26, 2017 at 1:34 am
Viewing 15 posts - 61 through 75 (of 450 total)