我有一个如下所示的表:
Make | Model
--------------
Ford | Bronco
Ford | Taurus
Honda | Accord
Ford | Thunderbird
Saab | 900
我需要一个SQL语句来仅输出列Make
中的Ford
、Honda
和Saab
。
SELECT DISTINCT Make
FROM YourTable
ORDER BY Make;
select distinct Make from table_name
SELECT DISTINCT Make
FROM YourTable
SELECT DISTINCT Make
FROM MyTable
就是这样。