krishna gokaraju

Comments

below query works by using JOIN select (x.A / y.B) as percentage from (select count(containerID) *100 as A from orion.containermembers where name like '%NodeName%' and Status = 1) x Join (select count (containerID) as B from orion.ContainerMembers where name like '%NodeName%') Y ON 1=1

in SWQL Query to calucate percentage Comment by krishna gokaraju June 2021
mismatched input 'percent' expecting identifer in the select clause is the error im getting

in SWQL Query to calucate percentage Comment by krishna gokaraju June 2021