按表中所有列的升序对数据进行排序 [英] Sorting the data by ascending order by all columns in a table

问题描述

是否可以在sql数据库中使用按列名排序超过1列的顺序？我的意思是我们可以使用在sql中组合多个列的列。比如A列和B列的顺序。

is it possible to use order by column name for more than 1 column in a sql database? i mean can we use order by column combining more than one column in a sql. like order by column A and column B.

推荐答案

非常可能。以下是SELECT语句的语法，其中ORDER BY子句中使用了多个列。

Very much possible. Following is syntax for SELECT statement where multiple columns are used in ORDER BY clause.

SELECT column_name1, column_name2
FROM table_name
ORDER BY column_name1 ASC|DESC, column_name2 ASC|DESC;

ASC | DESC意为你可以使用它们中的任何一个。

ASC|DESC meaning you can use either of them.

是的，它是可能的。请看这里： ORDER BY子句（T-SQL） [ ^ ]

Yes, it is possible. Please, see here: ORDER BY Clause (T-SQL)[^]

这篇关于按表中所有列的升序对数据进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！