mysql中如何查询表的第一条和最后一条记录
- WBOY原創
- 2016-06-07 14:58:112006瀏覽
无详细内容 无 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;
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;
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn