When using a count(disitnct) is it better to use an self-join or temp table to find redundant data, and provide an example?This one gets me, as I would just use a having (count) >1, but that wasnt the question.

Showing Answers 1 - 1 of 1 Answers


  • Sep 23rd, 2006

Use Count(*) gives you total number of records and use count(distinct(col_name)). if result of both are same number, then there is no redundant, duplicate data

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions