Question

Write a SQL SELECT query that only returns each name only once from a table?

Answer 1

To get the result as each name only once, we need to use the DISTINCT keyword.

SELECT DISTINCT name FROM table_name;