count and distinct

Hi experts, i have this query
select distinct c1,c2,c3,c4
from t1 inner join t2 on..
the number of rows is 22

but
select count(*)
from t1 inner join t2 on..
the number of rows is 24

As I can do a count the outcome of this query
select distinct c1,c2,c3,c4
......
enrique_aeoAsked:
Who is Participating?
 
ikamilCommented:
select count (*) from
  (select distinct c1,c2,c3,c4
......)

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.