title: MySQL query to get required data from table
body: <p>I have a table like this:</p>
  
  <pre><code>RS    Value    Measure    Feature
  1     x1       a          5k 
  1     x2       b          5k
  1     x3       b          10k
  1     x4       c          10k
  2     y1       a          5k
  2     y2       c          5k
  2     y3       b          10k
  2     y4       d          10k  
  .     .        .          .
  .     .        .          .
  .     .        .          .
  </code></pre>
  
  <p>there are diff. values of RS(like 1,2,3,4,....)</p>
  
  <p>now i want a query(taking only two values of RS, here 1,2) that returns the result as follows:</p>
  
  <pre><code>RS    Value    Measure    Feature
  1     x1       a          5k
  2     y1       a          5k
  1     x3       b          10k
  2     y3       b          10k
  .     .        .          .
  .     .        .          .
  </code></pre>
  
  <p>i.e, i want only those rows which have common Measure and Feature.</p>