如何编写sql,以便可以首先按A列而不是按B列对结果进行排序。如下所示:SELECT * FROM tbl WHERE predictor ORDER by col_A and ORDER by col_B
最佳答案
ORDER BY col_A, col_B
SQLite网站上的syntax diagrams解释了SQLite支持的SQL语法。
如何编写sql,以便可以首先按A列而不是按B列对结果进行排序。如下所示:SELECT * FROM tbl WHERE predictor ORDER by col_A and ORDER by col_B
最佳答案
ORDER BY col_A, col_B