select *
from(
SELECT
row_number() over(partition by [proDefine6], [brand], [cinvCode] order by [cinvCode]) r,
count(*) over(partition by [proDefine6], [brand], [cinvCode]) c,
*
FROM [dbo].[product]
) tmp
where tmp.c>1