mysql中如何查询表的第一条和最后一条记录 2015/06/15 14945 SELECT createdtime FROM `Z_2015-09-15` WHERE deviceid='460040271516782' limit 1; SELECT createdtime FROM `Z_2015-09-15` WHERE deviceid='460040271516782' order by id DESC limit 1;