mysql> select * from student order by score asc limit 0,1; +-----+-------+-------+ | sid | sname | score | +-----+-------+-------+ | 4 | 路六 | 54 | +-----+-------+-------+