title: SQL query looping for each value in a list
body: <p>New to SQL here - I am trying to get 1 row from a table matching to a particular criteria</p>
  <p>Typically this would look like</p>
  <pre><code>SELECT TOP 1 * 
  FROM myTable 
  WHERE id = 'abc' 
  </code></pre>
  <p>The output may look like</p>
  <pre><code> value    id
  --------------
    1       abc
  </code></pre>
  <p>The table has many entries for an 'id', and I am trying to get one entry per 'id'. Now I have list of 'id's. How would I execute something like</p>
  <pre><code>SELECT TOP 1 * 
  FROM myTable
  FOR EACH id
  WHERE id IN ('abc', 'edf', 'fgh')
  </code></pre>
  <p>Expecting result like</p>
  <pre><code> value    id
   --------------
    1       abc
    10      edf
    12      fgh
  </code></pre>
  <p>I do not know if it is some sort union or concat operation, but would like to learn. I am working on Azure SQL Server</p>