查询结果排序
语法
SELECT field1, field2,...fieldN table_name1, table_name2...
ORDER BY field1, [field2...] [ASC [DESC]]
只要field被列出,就可以排序
可以根据多个字段排序
ASC
是顺序,DESC
是逆序可以结合
WHERE...LIKE
条件
参考
Last updated
Was this helpful?
语法
SELECT field1, field2,...fieldN table_name1, table_name2...
ORDER BY field1, [field2...] [ASC [DESC]]
只要field被列出,就可以排序
可以根据多个字段排序
ASC
是顺序,DESC
是逆序可以结合
WHERE...LIKE
条件
Last updated
Was this helpful?