求SQL语句(10)

BBH 是INT TH是NVARCHARbbh th1 A2 A3 A4 A1 B2 B3 B 想删后只有bbh th4 A3 BDELETE FROM t3WHERE ((STR(MAX(bbh)) + th) NOT IN (SELECT STR(MAX(bbh)) + th AS bbhth FROM t3 GROUP BY th)) 这语句报错，怎么写？

where 语句里面的max不用加。

接受答案了.