一条复杂的SQL语句

Question

如何取出bh=11000119和11000120的最大je,并删除。求高手帮忙

Answer 1

delete from table where 主键=(select 主键 from table where (bh = 11000119 or bh = 11000120) and je = (select max(je) from table where bh = 11000119 or bh = 11000120)))