'//foaf:name', а не '//<foaf:name>'
SELECT
*
FROM
tableName
WHERE
fieldName IN (
SELECT
fieldName
FROM
tableName
GROUP BY
fieldName
HAVING COUNT(fieldName) > 1
);