title: Distinct value in two column
body: <p>I have a query in mysql</p>
  
  <pre><code>select f1,f2,f3 from tableName;
  </code></pre>
  
  <p>I want to remove duplicate value in field f1 and f2 only,</p>
  
  <p>I have tired as follows</p>
  
  <pre><code>select f1,f2,f3 from tableName
  group by f1,f2;
  </code></pre>
  
  <p>But it will remove duplicates in f1 only.Any body can suggest me that how to remove duplicates in f1 and f2.</p>
  
  <pre><code>topic_id    topic_name                    question_type
  2237    Understanding Diversity           Comprehensive
  2237    Understanding Diversity           Easy
  2237    Understanding Diversity           Application
  44315   Bhasha, boli, lipi, or Vayakaran  Intermediate
  </code></pre>
  
  <p>above is sample output having distinct value in question_type column only
  here i want to remove duplicates from question_type and topic_id</p>
  
  <p>expected output: having both topic_id and question_type distinct values</p>
  
  <pre><code> 44315  Bhasha, boli, lipi, or Vayakaran  Intermediate
   2237   Understanding Diversity           Comprehensive
  </code></pre>