Query examples to find items that have more than one row in a table:
SELECT department, COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 25000
GROUP BY department
HAVING COUNT(*) > 10;
SELECT key FROM table
group by key
having COUNT(*) > 1