But i would also have to check if they have codes in ('0260','0261','0262','0263') because not every claim may have these codes. ... View more

This is how the table will look like    claimnumber code 101 0260 101 0261 101 0262 101 0865 102 0260 102 0261 102 0560     Output   claimnumber code 101 0260 101 0261 101 0262 101 0865   Here we will not be selecting claim 102 because it has '0560' code in it but we will select 101 as it has codes which are  in  ('0260','0261','0262','0263') ... View more

For example. I am a member who is having a condition col(1,2,3) but i should not have condition col(4,5,6) and charged amt>25.. I am a member who is having conditions(1,2,3) and also conditions (4,5,6) and my chargedamount>100 ... View more

Because the Col has (1,2,3) and col (4,5,6) and having charged Amount >100 ... View more

I need to check if the member has a particular claim(COL) (1,2,3)  but should not contain sub claim (4,5,6)   So first condition: Billtype contains 13% and Col in (1, 2, 3) but Col not in (4,5,6) and the chargedamount>20   So the first condition would not be satisfied because we need only members who have col(1,2,3) but not (4,5,6) within the subquery    Second Condition: Billtype contains 13% and Col in (1, 2, 3) and Col in (4,5,6) and the chargedamount>100   The second condition will be satisfied as Col contains (1,2,3) and also (4,5,6) and charged amount>100    INPUT:   client id Order ID billtype col Chargedamount 1 1 138 1 20 1 2 138 4 5 1 3 137 2 10 1 4 136 3 25 1 5 139 5 150 1 6 137 6 700   OUTPUT:   1 5 139 5 150 1 6 137 6 700 ... View more

Okay Let me put it up in a more clear way.   I need to check if any of the conditions is true in the table.   Column1= 13* AND column2 IN (1, 2, 3) AND  column2 not IN (4, 5, 6) AND  ChargedAmount  > 20 OR Column1= 13* AND column2 IN (1, 2, 3) AND column2 IN (4, 5, 6) AND ChargedAmount  > 100   Can you help in coding the above specification?               ... View more