程序:
selectsum(t.tx) , sum(ch.rx) from
"Event" as eleftjoin "TXPC"as t one.oid =t.the_event
leftjoin"Channel+" as chon e.oid=ch.the_event
group by e.time having sum(t.tx) is not null or sum(ch.rx) is not null
以上程序得到一个表,有两个字段:sum(t.tx)与sum(ch.rx).现在要求求出 [sum(t.tx)>9 andsum(ch.rx).<7的条件的行数]/[表总行数]
求解
