示例代码:
SELECT s.sitename,c.* FROM CAIJI c,site s WHERE c.stationID=s.stationID ORDER BY checktime desc,c.checkID desc
解析:使用多列进行排序时,左边的列的排序优先级高于右侧
ORDER BY checktime ,checkID
注: // CHECKTIME升序 CHECKID升序
checktime 升序排序后再对 checkID 进行升序排序
ORDER BY checkID DESC,CHECKID
注: // CHECKTIME降序 CHECKID升序
checktime 降序排序后再对 checkID 进行升序排序
ORDER BY checktime ,checkID DESC
注: // CHECKTIME升序 CHECKID降序
checktime 升序排序后再对 checkID 进行降序排序
ORDER BY checktime DESC,checkID DESC
注: // CHECKTIME降序 CHECKID升序
注:checktime 降序排序后再对 checkID 进行降序排序