根据我所遇到的应用情况,总结了以下3中简单的语句
1. select *,(select field from table t2 order by field) s from table t1
2. select t1.* from table t1 where t1.field=(select min(t2.field) FROM table t2 )
3. select * from table t1 where not exists(select 1 from table t2 where t1.id= t2.id and t1.filed> t2.filed) limit 1
效率没有专门去测试过,大致2>3>1
适用多表连接或者group无排序情况
欢迎补充互相学习