Inst count only approve

Ram ram

6y773

I having one table in that mutiple institute each institute 136 drugs and district code for every district some institute and one columns is approve each drug now what i want approve institute count in this one instite some drugs not approved means need to show not approved only 136 drugs approve means that institute approve count display and not approved instcount need to disply need to display approve inst count district wise any body help for this query example selsect count(instid), case (approve)= group by dcode like that

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
Can you please elaborate, what doc type?
0
Ram ram6y ago
thanks you for giving replu but i am asking in this doc type
0
Nisha Regil6y ago
You can try using a query like this. Here I am trying to give you idea about the query, since I dont know the exact column names and table name.

Select count(drugs), sum(approve) as approvecount, sum(notappove) as notappovecount,districtcode from (
select drugs, case when (approve =1) then 1 else 0 end as approve,
case when (approve=0) then 1 else 0 end as notappove,
districtcode from tablename
) a group by districtcode

Hope it makes sense to you.
0