sql求最大,Orz
sflbh sj sl
050102 04.00
060101 01.00
050102 74.00
050102 112.00
050102 125.00
050102 132.00
050102 141.00
050102 161.00
060101 161.00
050102 202.00
060101 201.00
050102 234.00
select
*
from
TB t
where
not exists(select 1 from TB where sflbh=t.sflbh and sl>t.sl)