title: Find rows with duplicates in three columns without specifying value?
body: <p>Ive got a table like this, where I'm looking for unnecessary duplicate rows:</p>
  
  <p><img src="https://i.stack.imgur.com/3d3id.png" alt="enter image description here"></p>
  
  <p>I want to find any rows where the First Name, Last Name, and Occupation columns are identical - in this case rows 1 and 3. I don't want to specify what the identical values should be as I dont know.</p>
  
  <p>I've tried the answer to <a href="https://stackoverflow.com/questions/1786533/find-rows-that-have-the-same-value-on-a-column-in-mysql">this question</a>, but I dont think it applies to this case.</p>