title: Show only first row in SQL Server query
body: <p>I want only the first row to show up in this query. However, because each user has a distinct service, the users show up more than once. I only want to show the first row then the other rows in a separate query <code>ORDERING BY 'id'</code>.    </p>
  
  <pre><code>SELECT DISTINCT TOP (7)
      id,
      fname,
      lname,
      dob,
      services
  FROM 
      T1
  ORDER BY 
      id
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>id  fname   lname   dob         services    
  ------------------------------------------
  100 Joe     Blue    2/20/2001   JDT 
  100 Joe     Blue    2/20/2001   VOCP    
  101 Mark    Pink    1/5/2000    OPAP    
  101 Mark    Pink    1/5/2000    AARCHD  
  102 Wally   Green   1/2/2000    AARCHD  
  102 Wally   Green   1/2/2000    OPAP    
  103 Steve   Yellow  1/10/2000   AARCHD  
  </code></pre>