【SQL】ORDER BY 排序
单个字段默认升序排列SELECT * FROM Orders ORDER BY name1降序排列SELECT * FROM Orders ORDER BY name1 DESC一个字段的排序按照升序或降序显示两个字段排序SELECT * FROM Orders ORDER BY name1, name2//两个字段都按升序排列两个字段都排序,第一个字段比第二个字段具有更高的优先级,例如:SELECT * FROM Orders ORDER BY name1 DESC, n
原创
2020-10-11 15:35:54 ·
304 阅读 ·
0 评论