case statment for non ONE TO ONE value

13 Views Asked by Ra Ba At 18 May 2023 at 15:33

I wrote a query with case statment but I have a problem with non ONE-TO-ONE results. In particulare:

case when Prova1=Prova2 then "ok" else "no" end

I wuold like how to order the column used in case statment in order to take the right value (see the example) enter image description here

find a work around

There are 0 best solutions below