title: SQL - Get top 10 Usernames starting with a Letter
body: <p>I've a long list of usersNames. And I'm trying to get the first 10 usernames starting with A, B, C, D ... using Visual Studio c# with a local DB.</p>
  
  <pre><code>SELECT  tmpA.UserName, tmpB.UserName ...
  FROM (  
  SELECT top 10 [UserName]
  FROM [Users]
  WHERE UserName LIKE 'A%'
  ) tmpA,
  (  
  SELECT top 10 [UserName] 
  FROM [Users]
  WHERE UserName LIKE 'B%'
  ) tmpB
  </code></pre>
  
  <p>I'm trying to get a result looking like this:</p>
  
  <pre><code>a   | b   | c   ...
  aa  | bb  | cc  ....
  aaa | bbb | ccc ...
  </code></pre>
  
  <p>Where Column 1 has the first 10 usernames starting with "A", Second column has the first 10 usernames starting with "B" ect.</p>
  
  <p>Hopefully one of you can help me. Thank you in advance</p>