Hi

 

I need a little reminder on how to do a calculation in a SQL statement:

 

I want to divide:

 

Select count(*) from events where scheduled_start >current_timestamp - 1
day

 

BY

 

Select count(*) from events where status not like '%Completed%' and
scheduled_start >current_timestamp - 1 day

 

THEN * 100

 

I have done this before by putting each statement in brackets but can't
quite remember!!!

 

Thanks

 

Ian

Dell Corporation Limited is registered in England and Wales. Company 
Registration Number: 2081369
Registered address: Dell House, The Boulevard, Cain Road, Bracknell,  
Berkshire, RG12 1LF, UK.
Company details for other Dell UK entities can be found on  www.dell.co.uk.