实例 PostgreSQL 使用 Select Distinct 语句实例

 
SELECT DISTINCT country FROM customers;        
                    

输出结果

 country
-------------
 Argentina
 Spain
 Switzerland
 Italy
 Venezuela
 Belgium
 Norway
 Sweden
 USA
 France
 Mexico
 Brazil
 Austria
 Poland
 UK
 Ireland
 Germany
 Denmark
 Canada
 Finland
 Portugal
(21 rows)