Re: Query pages printed by percentage of total?

[Francisco Wong-Li]

try this

select a.owner, a.printername, a.logDateTime, (sum(a.pagesprinted)/b.hojas) *100 as percet
from printlog a left join
( select logDateTime, printername, sum(pagesprinted) as hojas
from printlog
group by logDateTime,printername
) as b
on b.logDateTime = a.logDateTime
and b.printername = a.printername
where a.printername = 'lpt01'
group by a.owner,a.printername,a.logDateTime

you can use the a.printername and a.logdatetime optional but is necessary when use a range of date

saludos