title: How can i prevent duplicate rows being selected in a select query?
body: <p>I have been given the task of selecting key data from an Oracle database, but I am noticing that my select is returning duplicate rows. I don't need them for my report yet I don't want them to delete them. Could someone help to get only the data that I need. I have tried the following code but this doesn't help.</p>
  
  <pre><code>SELECT distinct bbp.SUBCAR "Treadwell",
         bbp.BATCH_ID "Batch ID",
         bcs.SILICON "Si",
         bcs.SULPHUR "S",
         bcs.MANGANESE "Mn",
         bcs.PHOSPHORUS "P",
         to_char(bcs.SAMPLE_TIME, 'dd-MON-yy hh24:MI') "Sample Time",
         to_char(bbp.START_POUR, 'dd-MON-yy hh24:MI') "Start Pour Time",
         to_char(bbp.END_POUR, 'dd-MON-yy hh24:MI') "End pour Time",
         bofcs.temperature "Temperature"
  FROM  bof_chem_sample bcs, bof_batch_pour bbp, bof_celox_sample bofcs
  WHERE bcs.SAMPLE_CODE= to_char('D1')
  AND bbp.BATCH_ID=bcs.BATCH_ID
  AND bcs.SAMPLE_TIME&gt;=to_date('01-jan-10')
  </code></pre>