How is the term “distinct” used in the context of access?

In SQL, DISTINCT is a keyword used to retrieve unique records from the database.

DISTINCT is commonly used in conjunction with a SELECT statement to specify the columns to be retrieved, in order to return unique values.

For example, the following query will return the values of the “column_name” column in the “access” table without duplicates.

Select unique values from the column_name in access table.

This query will return all unique values in the column without displaying the same value more than once.