الحصول علي بيانات باستخدام MAX

الساده الزملاء

أريد أن أحصل علي أعلي قيمة موجوده في حقل اسمة Serial فقمت بكتابة Script أدناه ولم يعطني المطلوب لكن أعطاني النتيجة كما في الصورة

SELECT     dbo.Employee.EmpCode, dbo.Employee.EmpEnFulName, dbo.Job.JobName, dbo.OrgStrucutreDET.unitName, dbo.Employee.CompCode, 
                      dbo.EmpContract.ContStDate, dbo.EmpContract.ContEndDate,max(dbo.EmpContract.Serial)as Serial
FROM         dbo.Employee INNER JOIN
                      dbo.EmpContract ON dbo.Employee.EmpCode = dbo.EmpContract.EmpCode AND 
                      dbo.Employee.CompCode = dbo.EmpContract.CompCode LEFT OUTER JOIN
                      dbo.Job ON dbo.Employee.CompCode = dbo.Job.CompCode AND dbo.Employee.Jobcode = dbo.Job.JobCode LEFT OUTER JOIN
                      dbo.OrgStrucutreDET ON dbo.Employee.CompCode = dbo.OrgStrucutreDET.CompCode AND 
                      dbo.Employee.DepartmentCode = dbo.OrgStrucutreDET.UnitPath

WHERE      

(dbo.Employee.EmpCode = '3872')
 and (dbo.Employee.CompCode = '001')

group by      

dbo.Employee.EmpCode, dbo.Employee.EmpEnFulName, dbo.Job.JobName, dbo.OrgStrucutreDET.unitName, dbo.Employee.CompCode, 
                      dbo.EmpContract.ContStDate, dbo.EmpContract.ContEndDate,dbo.EmpContract.Serial