select contact from (select numeredContact, row_number() over(partition by numeredContact.name, numeredContact.phone) as num from Contact numeredContact ) as contact where contact.num = 1

Caused by: java.lang.IllegalArgumentException: Component at index 0 has no alias, but alias is required