How can you extract only unique values from a column of names in an SQL query?

To extract only unique values from a name column in SQL, the keyword DISTINCT is used. It allows you to select only unique (non-repeating) records.

Example query:

SELECT DISTINCT name
FROM table;

This query will return a list of unique names from the name column of the table.