-- *** Test Data ***
CREATE TABLE #t
(
	COD char(4) NOT NULL
	,[Type] varchar(5) NOT NULL
	,Value varchar(5) NOT NULL
	,[Default] int NOT NULL
);
INSERT INTO #t
SELECT 'C001', 'WWW', 'XXXX', 0 
UNION ALL SELECT 'C001', 'EMAIL', 'YYY', 0
UNION ALL SELECT 'C001', 'EMAIL', 'ZZZ', 0
UNION ALL SELECT 'C001', 'CEL', 'NNN', 0
UNION ALL SELECT 'C002', 'WWW', 'XXXX', 0;
-- *** End Test Data ***

select * from #t;

WITH CODTypeOrder
AS
(
	SELECT *
		,ROW_NUMBER() OVER (PARTITION BY COD, [Type] ORDER BY Value) rn
	FROM #t
)
UPDATE CODTypeOrder
SET [Default] = 1
WHERE rn = 1;

select * from #t;

WITH CODTypeOrder
AS
(
	SELECT *
		,ROW_NUMBER() OVER (PARTITION BY COD, [Type] ORDER BY Value) rn
	FROM PeopleAddressMedia
)
UPDATE CODTypeOrder
SET [Default] = 1
WHERE rn = 1;