SQL: Select only one row of table with same value

Im a bit new to sql and for my project I need to do some Database sorting and filtering:

Let’s assume my database looks like this:

==========================================
|  id       |       email        | name
==========================================
|   1       |  [e-mail]      | John
|   2       |  [e-mail]      | Peter
|   3       |  [e-mail]      | Steward
|   4       |  [e-mail]      | Ethan
|   5       |  [e-mail]      | Bob
|   6       |  [e-mail]      | Patrick
==========================================

What should I do to only have the last column with the same email te be returned:

==========================================
|  id       |       email        | name
==========================================
|   3       |  [e-mail]      | Steward
|   5       |  [e-mail]      | Bob
|   6       |  [e-mail]      | Patrick
==========================================

Thanks in advance!

Answer

SQL Query:

    SELECT * FROM test.test1  WHERE id IN (
  SELECT MAX(id) FROM test.test1 GROUP BY email
);

Hope this solves your problem. Thanks.