title: Oracle SQL- column value being not distinct as criteria
body: <p>I'm having trouble formulating a SQL statement to return the values I want. I need to select data based on user ID, a second column's value, and a third columns value where the values in that column appear more than once. All columns are within the same table. </p>
  
  <p>Here's a rough outline of what my query looks like now, but the last AND statement obviously is just to give you an idea of what I want. A COUNT statement that would narrow the results down likely wouldn't work for me.</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE user_id = 123
  AND second_id = 1
  AND third_id having COUNT(1) &gt; 1;
  </code></pre>