title: Sql Query Filter
body: <p>I need to query a taken room which is present in all the dates from the table.</p>
  
  <p>My table data is</p>
  
  <pre><code>-----------------------------------
  |Room No | Date         |  Type   |
  -----------------------------------
  |1       | 1 JAN 2016   | AC      |
  |2       | 1 JAN 2016   | AC      |
  |3       | 1 JAN 2016   | Non AC  |
  |1       | 2 JAN 2016   | AC      |
  |3       | 2 JAN 2016   | AC      |
  |1       | 3 JAN 2016   | AC      |
  |2       | 3 JAN 2016   | AC      |
  |3       | 3 JAN 2016   | Non AC  |
  </code></pre>
  
  <p>Now I want the result Like </p>
  
  <pre><code>------------------------
  | RoomNo    |  Type    |
  ------------------------
  | 1         |   AC     |
  | 3         |  NON AC  |
  </code></pre>
  
  <p>See the above example room no 2 is not present on  2nd jan so it's not required.</p>