Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table PAT_ENC (
PATID	int,
PROVID	int,
PROVCOUNT int);
INSERT INTO PAT_ENC (PATID, PROVID, PROVCOUNT) 
SELECT 1,	3,	1 FROM DUAL UNION ALL
SELECT 2,	4,	6 FROM DUAL UNION ALL
SELECT 2,	3,	2 FROM DUAL UNION ALL
SELECT 2,	8,	1 FROM DUAL UNION ALL
SELECT 3,	4,	6 FROM DUAL UNION ALL
SELECT 4,	1,	8 FROM DUAL UNION ALL
SELECT 4,	2,	3 FROM DUAL;
7 rows affected

WITH COUNTED AS
(SELECT 
  PATID, 
  PROVID, 
  PROVCOUNT,
  RANK() OVER (PARTITION BY PATID ORDER BY PROVCOUNT DESC) ranking
FROM PAT_ENC)
SELECT
  PATID, 
  PROVID, 
  PROVCOUNT
FROM COUNTED
WHERE ranking = 1;


PATID
PROVID
PROVCOUNT


1
3
1

2
4
6

3
4
6

4
1
8