I am trying to find if all the cell of the col called isComplete is true for an id.then it should retuen something to let me know they all are true or not.i tried myself and came up with this query and in my code I can do I check if the value is 0 then all the records of that col is true. I have attached the table data also to make things easy to understand.
sum(case when iscomplete='true' then 0 else 1 end ) as complete
from supplierorderdetails sod
sod.supplierorderid = 2