在SQL中对两列进行排序 [英] Sorting for two columns in SQL

问题描述

我有一张如下表格



FirstName |姓氏| YearOfBirth

----------------------------------------

托马斯| Alva Edison | 1847年

本杰明|富兰克林| 1706

托马斯|更多| 1478

托马斯|杰斐逊| 1826



我想按Lastname ASC和YearOfBirth ASC这两个栏目排序



有可能吗？任何人都可以帮助我。



我尝试过：



我试过了，但只有一列正在工作。对于这两列都没有用。

I have a table like below

FirstName | LastName | YearOfBirth
----------------------------------------
Thomas | Alva Edison | 1847
Benjamin | Franklin | 1706
Thomas | More | 1478
Thomas | Jefferson | 1826

I want to sort by both columns like 'Lastname ASC' and 'YearOfBirth ASC'

Is it possible??Can anyone help me.

What I have tried:

I tried ,but only for one column is working.For both columns it is not working.

推荐答案

试试..

try ..

SELECT * FROM table ORDER BY Lastname DESC, YearOfBirth ASC

引用：

是否有可能？任何人都可以帮助我。

Is it possible??Can anyone help me.

可以通过列和然后订购另一个（例如，参见 MSDN [ ^ ]）。在您的方案中，它将是

It is possible to order by a column and then by another one (see, for instance MSDN[^]). In your scenario it would be

... ORDER BY Lastname ASC, YearOfBirth ASC;

请注意，在您的样本数据中，'YearOfBirth'的排序将无关紧要。

Please note, in your sample data the ordering by 'YearOfBirth' would be irrelevant.

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