mysql - 如何选择两列中的不同行并对它们分别进行排序

Question

我有这个sql:

SELECT DISTINCT car_year, car_make 
FROM cars
GROUP BY car_year, car_make 
ORDER BY car_year ASC, car_make ASC

它返回:

car_year | car_make
-------------------
    2009 | TOYOTA
    2011 | AUDI
    2013 | ACURA
    2014 | AUDI
    2015 | KIA
    2015 | ACURA

我需要它更加独特(独特)，并且几乎将其作为单独的列表，即使它们存储在同一个表(汽车)中。像这样的事情:

car_year | car_make
-------------------
    2009 | ACURA
    2011 | AUDI
    2013 | KIA
    2014 | TOYOTA
    2015 | 

Answer 1

SELECT DISTINCT car_year
FROM cars
ORDER BY car_year

SELECT DISTINCT  car_make 
FROM cars
ORDER BY car_make