You Asked
TABLEA
******
C1 C2 C3 (COLS)
* - -
- * -
* - *
- * *
I have 6(*) in the above table?
But when i select my table i get the count 6 result how? sir?
From my side i have done like
select count(c1) from tb....for 2
union
select count(c2) from tb....for 2
union
select count(c3) from tb...for 2
it individually gave me the answer.But i want 6 count number.
and Connor said...
select count(c1)+count(c2)+count(3) from t;
Is this answer out of date? If it is, please let us know via a Comment