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

catchu

The data types of columns A and B are both char

catchu

haigerrual


   
Cuddling requirements
The first floor can be achieved

－－－－－－－－－－－－－－－－－－－－
The statement on the first floor is too strong to be applicable. I mean there are many records like column A 0002 and column B 10. It is possible that column A is 12345 and column B is 08

catchu

Why are they all stuck together? ? ? Resend it again
Table I
Column A Column B
0001 1
0001 2
0001 3
0001 4
0001 5
0001 6
0001 7
0001 8
0001 9
0001 10
0001 11
0001 12
0002 10
0003 1
0003 2
0003 3
0003 4
0003 5
0003 6
0003 7
0003 8
0003 9
0003 10
0003 11
0003 12
－－－－－－－－－－

sinexe

Still don't understand what it means

catchu

sinexe


   Still don't understand what it means

-------------------------------------------
Catch you! ! Your statement can basically solve the problem, but how do I write if column B is not equal to 12? ? ?

catchu

Almost, thank you! !

fanfan1980

such?
select * from t where column A = '0002' and column B <> '12'

sinexe

such?
select * from t where column B <> '12'
A little dizzy

sinexe

Still like this?
select column A, min(column B) from t group by A column having count(*) = 1 and min(column B) <> '12'

catchu

Can be found, and finally ask another question: I now want to update column B = 12 how to write? ? ?