QString str = QString("SELECT Date, Time, People, Event FROM TB_LOG WHERE People = \"%1\" order by Date desc limit 0,2000").arg("模式"); //order by Time desc QSqlQuery query; query.exec(str);
如以上所示,为一段简易的qt数据库查询代码。
order by Date desc
此为倒序的查询
order by Date asc
此为正序的查询。
通过对日期的正序和倒序,可以比较清晰的看到,我们所需要的数据。