select * from 表名 LIMIT 0,1 select * FROM 表名 ORDER BY 字段名 DESC LIMIT 1 SELECT * from 表名 where 字段名 = (SELECT max(字段名) FROM 表名) SELECT * from 表名 where 字段名 = (SELECT max(字段名)) ORDER BY 字段名 DESC LIMIT 3