mysql 查询某字段最小的记录

根据我所遇到的应用情况,总结了以下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无排序情况

欢迎补充互相学习