select *
from table
where (select bnum
from table
where max(bnum))
from table
where (select bnum
from table
where max(bnum))
我一个不懂世事的人，希望能在这里学到我想学的一些东西。
select * from table a join
(select max(bnum) as bnum,name from table group by name) b
on a.name=b.name and a.bnum=b.bnum
