• Although the article was well-written and a good introduction to DISTINCT, I didn't give it many stars.

    Why? I found that the article didn't introduce us anything that can't be found on the MSDN pages.

    It would've been nice if the following were included in the article:

    * a critical look on the performance impact of DISTINCT

    * although the alternatives of GROUP BY are listed, it is not explained if one construct is prefered above the other, or if they are equivalent (if you look at the execution plans)

    * the behaviour of DISTINCT with NULL values and in aggregate functions

    However, the article itself was written well, with no obvious spelling mistakes and it had clear examples, so Sarvesh, as Jeff already mentioned, don't let this withhold you to write future articles!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP