+----+-----------+
| id | name      |
+----+-----------+
|  1 | error1    |
|  2 | error2    |
|  3 | error3    |
|  4 | error2    |
|  5 | error3    |
+----+-----------+

+----+-----------+
| id | name      |
+----+-----------+
|  1 | error1    |
|  4 | error2    |
|  5 | error3    |
+----+-----------+

from sqlalchemy import func
db.session.query(func.max(example.id),example.name).group_by(example.name).all()