title: List value by group by sql server
body: <p>I have a table as below</p>
  
  <pre><code>Id | PriceCardId | Days
  1  |   1         | 2
  2  |   1         | 4
  3  |   1         | 5
  4  |   1         | 6
  5  |   1         | 3
  6  |   2         | 5
  7  |   2         | 3
  8  |   3         | 6
  </code></pre>
  
  <p>How to write SQL query to get all PriceCardId has Day contain </p>
  
  <pre><code>List&lt;int&gt; days
  Example days = [2,4,5,6], with data as above result is 1
  </code></pre>
  
  <p>Thanks!</p>