count different data with same name in column as 1 count sql server
<p>sorry i want to ask about this i already try but still cant get it
ok i have a table like this </p>

<pre><code>tblcount
-----------------------
no_req  no_order    no_grn   
R001    D001        G001
R001            
R001    D001        G001
R002    D002        
R002    D002        G002
R003    D001        G001
R004    D003        G002
R004    D003        G002
R005    D003     
R005    D003
R006    D004        G002
R006    D005        G003
R006    D007
R007    D007        G005
R007    D008        G006
</code></pre>

<p>I want to count with criteria like this.
example, from table above there is 3 data of R001 from no_req but only 2 from no_order and no_grn so it doesnt count. it will only count the complete data. something like this:</p>

<ol>
<li>no_req R001 with 3 data but no_order and no_grn only 2 = it doesnt count</li>
<li>no_req R002 with 2 data no order with 2 data but no_grn only 1 = it doesnt count</li>
<li>no_req R003 with 1 data no_order and no_grn with 1 data = it count 1</li>
<li>no_req R004 with 2 data no_order and no_grn with 2 data = it count 1</li>
<li>no_req R005 with 2 data no_order with 2 data, no_grn 0 = it doesnt count</li>
<li>no_req R006 with 3 data no_order with 3 data, no_grn 2 data = it doesnt count</li>
<li>no_req R007 with 2 data no_order and no_grn with 2 data = it count 1 </li>
</ol>

<p>so from data above I can get count result = 3
what should I do so I can get that count result = 3 from table above</p>