It is not exactly what you are looking for, but you wish to display just the duplicate titles you can
Select title
from your_table
group by title
having count(id) > 1
You can also use (but I haven't personally tried it)
select c1.id, c2.id, c1.title
from your_table c1, your_table c2
where c1.id < c2.id and c1.title = c2.title