Hi list,
Firebird 2.5RC3 (Debian version) on Debian Squeeze
Trying to calculate percentages and totals (and hoping I'm getting the
expression right):
SELECT runs.id, count(rv.name),
((count(tr.resultvalue))*100)/(SELECT COUNT(resultvalue) FROM
testresults where testresults.testrun=runs.id)
from
t
> Firebird 2.5RC3 (Debian version) on Debian Squeeze
>
> Trying to calculate percentages and totals (and hoping I'm getting the
> expression right):
> SELECT runs.id, count(rv.name),
> ((count(tr.resultvalue))*100)/(SELECT COUNT(resultvalue) FROM
> testresults where testresults.testrun=runs.id)
> f