Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can anyone explain me how the logical operators takes place in set analysis for below expression :
Count({$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct Lenskey)
i.e; which of the condition are correct for above set analysis
1.) Select Count (Distinct Lenskey) From table where DS ='Fail' or DS='Pass' or LR='Fail' or LR='Pass'
2.) Select Count (Distinct Lenskey) From table where DS ='Fail' and DS='Pass' and LR='Fail' and LR='Pass'
3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')
Thanks in advance
Venkat
It is your:
3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')
As in this bit means either Fail OR Pass
{"Fail","Pass"}
and the comma in the middle seperate things as an AND
{$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct
Best Regards, Bill
Venkat
It is your:
3.) Select Count (Distinct Lenskey) From table where (DS ='Fail' or DS='Pass') and (LR='Fail' or LR='Pass')
As in this bit means either Fail OR Pass
{"Fail","Pass"}
and the comma in the middle seperate things as an AND
{$<DS={"Fail","Pass"}, LR={"Fail","Pass"}>} Distinct
Best Regards, Bill
i will say Option 3
Regards.
Johann
Thanks to all your suggestion.
Regards,
Venkat