Mysql only do not select duplicated values

Question

I am looking for a way to run a simple SELECT statment. I have a table which has two columns: id and email.

I want to run a SELECT statment that won't return duplicate values. For example, take the following data:

1   [email protected]
2   [email protected]
3   [email protected]
4   [email protected]

I want it to return only the following:

1   [email protected]
2   [email protected]

...and skip the duplicate values.

Answer 1

SELECT MIN(id), email FROM some_table GROUP BY email

Answer 2

SELECT DISTINCT email FROM table