If I want unique values only for a particular column, can I use DISTINCT? If not, what should I use?

[Mike M]

Hello everyone,

I would like to have unique email addresses in the Email column.

The table:

+----+------------------+
| Id | Email |
+----+------------------+
| 1 | [e-mail] |
| 2 | [e-mail] |
| 3 | [e-mail] |
+----+------------------+

The result should be:

+----+------------------+
| Id | Email |
+----+------------------+
| 1 | [e-mail] |
| 2 | [e-mail] |
+----+------------------+

My SQL attempt:
SELECT DISTINCT Id Email
FROM Person

It doesn't give me the result I want. What is wrong with this?

Thank you!