title: How to apply DISTINCT sql query on some of fields and return all columns?
body: <p>How i could achieve distinct for some of fields only and return result set include all columns ?</p>
  
  <p>below is sql query:</p>
  
  <pre><code>       SELECT DISTINCT FIELD1,FIELD2,FIELD3,FIELD4,FIELD5
         FROM T1
         RESULT COUNT - 5000
         Observation - it is distinct for all five fields as DISTINCT APPLIED ON WHOLE RECORD.
                        BUt, FIELD1, FIELD2,FIELD43 are just duplicated and vary only FIELD 4, AND field5
  </code></pre>
  
  <p>Another sql query (Just skipped last two columns).</p>
  
  <pre><code>       SELECT DISTINCT FIELD1,FIELD2,FIELD3     --SKIPPED FIELD4,FIELD5
         FROM T1
         RESULT COUNT - 3000 
        OBVESERVATION - it shows only distinct record for all three field.
  </code></pre>
  
  <p>PROBLEM: i need distinct record for three fields only (FIELD1,FIELD2,FIELD3) and it should include - FIELD4,FIELD5</p>
  
  <p>How it could achieve.</p>
  
  <p>Thank You</p>