Detective novel where the detective turns out to be the culprit

Possibly massive spoilers obviously. I'm rereading Oedipus Rex, and I love the tension of Oedipus investigating his own crime, so I would love to hear any others.

(Spoiler tags probsbly aren't necessary for a 2,500 year old story which is a cultural touchstone, but thought it best to play safe!)