Databases
StackOverflow2013
Postsdbo
POHow can i count this variables in my DB?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can i count this variables in my DB?
    text
    copied!<p>Colud you please help me about this problem ?</p> <p>I have 4 variables</p> <ol> <li>XTSM is between 0~200</li> <li>XTS is between 0~2</li> <li>XRX is 0~3</li> <li>XHAN is 0~7</li> <li>ZHTYPE is one of these : (1)TCHF_HLF (2)TCHSD (3)TCHFULL </li> </ol> <p>they are related to their with this shape .</p> <p><code>XTSM-&gt;XTS-&gt;XRX-&gt;XHAN-&gt;ZHTYPE</code> (Just Logical)</p> <p>this means : </p> <ul> <li>Each XTSM has 3 XTS (0-2)</li> <li>Each XTS has 4 XRX (0-3)</li> <li>Each XRX has 8 XCHAN (0-7)</li> <li>and Each line has a type of ZHTYPE</li> </ul> <p>I have a DB file with 14000 lines; in this file these variables specified, For example XTSM is between 0~200 but usually it's less than 200 and maybe for example specified 0~60 but it's never greater than 200; and it's true for XTS,XRX and XCHAN of course ... so we must make all variables as a dynamic ;</p> <p>this is a part of file (for example UPDATED) : <a href="http://www.4shared.com/file/210566155/c080d93a/db_online.html" rel="nofollow noreferrer">http://www.4shared.com/file/210566155/c080d93a/db_online.html</a></p> <p>I want get this output ? (I want to show XTSM and XTS to output and in the backgroud must calculate all of them) please help me </p> <pre><code>----Type------------------Total---------------------Total of ZHTYPE----------------- XTSM:0/XTS:0 in this case is : 29 TCHF_HLF:28 TCHSD:1 TCHFULL:0 XTSM:0/XTS:1 No. of found XTSM:0/XTS:2 No. of found XTSM:1/XTS:0 No. of found XTSM:1/XTS:1 No. of found XTSM:1/XTS:2 No. of found </code></pre> <p>I don't know but i think it's maybe this ; No ? It's just pseudo code :</p> <pre><code>for(i ; i&lt; (Total of XTSM) ; i++){ for(j ; j&lt; (Total of XTS) ; j++){ for(k ; k&lt; (Total of XRX) ; k++){ for(l ; l&lt; (Total of XCHAN) ; l++) Print( Total of XTSM:x/XTS:y); } } } </code></pre> <p>Thanks for your help ...</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload