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
-
mismatched input 'percent' expecting identifer in the select clause is the error im getting