SELECT ROW_NUMBER() OVER (PARTITION BY EmployeeGroup ORDER BY EmployeeName), * FROM Employee