How to filter duplicate value in two table row fields?

Question

SQL

Good afternoon, tell me please - how can I select the table below on the left with a request to get a table like on the right
. you need to remove the duplicate, while considering the duplicate as the one whose TITLE and HASH values ​​are equal (i.e. how to consider them together as unique), i.e. if such occur, then only leave one option (in this example, the value of which ID is the largest)

Answer 1

SELECT MAX(ID), TITLE, HASH
FROM <tablename>
GROUP BY TITLE, HASH