Show Only First Row In MS SQL Query : 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 `ORDERING BY 'id'`.    

    SELECT DISTINCT TOP (7)
        id,
        fname,
        lname,
        dob,
        services
        FROM T1
        ORDER BY id

    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	




