I need to update a table based on 4 conditions

1) If there are 3 0r more columns with the same conditions as below

2)if column A starts with "ABX"

3)and If column B is same for all 3 columns

4)If value of column c ='123'

then update column D = True else false

for example

A B C D

ABX12 xyz 123 True

ABX13 xyz 123 True

ABX14 xyz 123 True

ABX15 xyz 124 False

ABX16 xyz 124 False

onlt first 3 colums have true bcos

there are 3 rows which start with ABX

and column B is same for all three and

column C value is '123' thats why D is True

if any of these conditions dosent satisfy the dis false

Open in new window