Sample SQL Function DISTINCT in ODBC when there are Multiple Values in a Column

In a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes users want to list only the different (distinct) values in a table.

The DISTINCT keyword can be used to return only distinct (different) values.

SYNTAX:
SELECT DISTINCT column_name(s) FROM table_name

EXAMPLE:
SELECT DISTINCT lastname FROM Customers

Customers

--------------------------------------------
* firstname * lastname *
--------------------------------------------
* John * Doe *
* Mary * Doe *
* Jason * Smith *
---------------------------------------------

QUERY:
SELECT DISTINCT lastname FROM Customers

RESULT:
----------------------
* lastname *
----------------------
* Doe *
* Smith *
-----------------------