select ... from #tmp,tab where ....作者: hannibal 时间: 2005-12-02 23:30
select * from tbname a
where (select count(*)
from tbname b
where a.a =b.a
and a.b < b.b )<1
order by 1作者: megaman 时间: 2005-12-03 10:14
select * from tbname group by a having b=max(b)作者: coocool 时间: 2005-12-04 19:33