title: MSSQL - Retrieve ID if condition for all rows of this ID is valid
body: <p>Just a quick question. I have table like this:</p>
  
  <pre><code>╔══════╦═════════════╗
  ║ id   ║     date    ║
  ╠══════╬═════════════╣
  ║   90 ║  2100-01-01 ║
  ║   90 ║  2100-01-01 ║
  ║   91 ║  2100-01-01 ║
  ║   91 ║  null       ║
  ║   92 ║  2100-01-01 ║
  ║   92 ║  2100-01-01 ║
  ║   92 ║  null       ║
  ║   93 ║  2100-01-01 ║
  ╚══════╩═════════════╝
  </code></pre>
  
  <p>I want to write a query that will retrieve only those IDs that have a date higher than current date in ALL of its rows. I that case:</p>
  
  <pre><code>╔════╗
  ║ id ║
  ╠════╣
  ║ 90 ║
  ║ 93 ║
  ╚════╝
  </code></pre>
  
  <p>Thanks!</p>