Ask the heroes, can such a query be realized? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

sinexe

update t
set column B = 12
where condition

catchu

sinexe


   update t
set column B = 12
where condition
-----------------------------------
I want to use the query result you gave me when the condition is updated

sinexe

--Try
update t _a
set column B = 12
where exists(
    select 1
    from t
    group by column A
    having count(*) = 1
       and min (column B) <> '12'
       and _a.Column A = column A
       and _a.B column = min (column B)
)

快乐时间

select * from t where column A = '0002' OR column B = '10'
can be realised