If you want the highest value of multiple rows, this is also a working solution:

select

IDActivity

, MAX(Subject) as 'Subject'

, MAX(ProjectName) as 'ProjectName'

, MAX(Fullname) as 'Fullname'

, MAX(CusName) as 'CusName'

from table_name

group by IDActivity