i want to get number of feilds in column 1 in table 1 and table 2
and i will do the calculations as ((no of field in column1 in table1/no field in column1 in table2)*100)
such a way i wat to calculate it for all the columns continously...
please help me
posted 5 years ago
I am not sure I understand what you mean by
i want to get number of feilds in column 1 in table 1
Are you saying you have multiple values in one column ?
If that's the case it is a very suspicious database design and maybe you should normalize your database structure before solving your calculation problem.
It may even make things a lot easier for you.
SCJP 5 , SCWCD 5, SCEA 5
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads