指定某个列进行排序,ASC 为升序,DESC 为降序。
SELECT * FROM Consult ORDER BY add_time DESC LIMIT %d,%d 按add_time 减序排列
SELECT * FROM Consult ORDER BY add_time ASC LIMIT %d,%d 按add_time 升序排列
原文链接:https://www.f2er.com/sqlite/200066.html指定某个列进行排序,ASC 为升序,DESC 为降序。
SELECT * FROM Consult ORDER BY add_time DESC LIMIT %d,%d 按add_time 减序排列
SELECT * FROM Consult ORDER BY add_time ASC LIMIT %d,%d 按add_time 升序排列
原文链接:https://www.f2er.com/sqlite/200066.html