Setting | Description |
Yes | Displays only the records in which the values of all fields displayed in Datasheet view are unique. |
No | (Default) Displays all records. |
Country | Company name |
Brazil | Familia Arquibaldo |
Brazil | Gourmet Lanchonetes |
Brazil | Hanari Carnes |
France | Du monde entier |
France | Folies gourmandes |
Germany | Frankenversand |
Ireland | Hungry Owl All-Night Grocers |
SELECT DISTINCT Customers.Country
FROM Customers;
Countries returned |
Brazil |
France |
Germany |
Ireland |