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.

  • Interview Candidate
  • 1
  • 1543

Showing Answers 1 - 1 of 1 Answers

opbang

  • 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