To select information from a database without listing duplicates in the same column, use the SELECT DISTINCT statement in SQL. 

Syntax:

1

SELECT DISTINCT <column name(s)> FROM <table name>

For the column name(s) field, enter the names of the columns you would like to pull the distinct data from in the table.

For the table name, enter the name of the table from which you are accessing the data.

Examples:

Suppose we have the following dataset in our database within a table named birthdays:

To select distinct last ones, use the following query:

1

SELECT DISTINCT LastName FROM birthdays

Which would yield the following result set: