This was a good introductory article about DISTINCT, and using GROUP BY.

Please see posting by srivatsa.hg to correct the typo. My understanding was that the PostalCode were meant to be different for 'Sarvesh' and 'Param'.

'select * from DistinctTutorial' was meant to be 'select * from DuplicateTest'. Please verify and correct as needed.