29-12-2015 17:45:25 MSSQL / Basics 0 Bookmark(s) 188 View(s)

 

The keyword DISTINCTensures that the combination of values on each row in the resultset is unique. This can be used for example to list the countries where your costumers are from.

SELECT DISTINCT Country FROM Customers;