title: Select all rows from SQL based upon existence of multiple rows (sequence numbers)
body: <p>Let's say I have table data similar to the following:</p>
  
  <pre><code>123456 John  Doe 1  Green  2001
  234567 Jane  Doe 1  Yellow 2001
  234567 Jane  Doe 2  Red    2001
  345678 Jim   Doe 1  Red    2001
  </code></pre>
  
  <p>What I am attempting to do is only isolate the records for Jane Doe based upon the fact that she has more than one row in this table. (More that one sequence number)
  I cannot isolate based upon ID, names, colors, years, etc...
  The number 1 in the sequence tells me that is the first record and I need to be able to display that record, as well as the number 2 record -- The change record.</p>
  
  <p>If the table is called users, and the fields called ID, fname, lname, seq_no, color, date. How would I write the code to select only records that have more than one row in this table?  For Example:</p>
  
  <p>I want the query to display this only based upon the existence of the multiple rows:</p>
  
  <pre><code>234567 Jane  Doe 1  Yellow 2001
  234567 Jane  Doe 2  Red    2001
  </code></pre>
  
  <p>In PL/SQL</p>