Please, read my comment to the question first.
I think you need something like this:
SELECT PageNo, MAX(PCount) As PCount
FROM [table]
WHERE IKey= 12732
GROUP BY PageNo
or
SELECT PageNo, MAX(PCount) OVER(PARTITION BY PageNo ORDER BY PCount DESC) As PCount
FROM [table]
WHERE IKey= 12732
For further details, please see:
MAX (Transact-SQL) - SQL Server | Microsoft Docs[
^]
OVER Clause (Transact-SQL) - SQL Server | Microsoft Docs[
^]
Submit an article or tip