Database

Finding Duplicate Rows

SELECT p.contract, p.sub_contract, p.problem_id, count(p.problem_id)
FROM ld_problems p
GROUP BY p.contract, p.sub_contract, p.problem_id
HAVING count(p.problem_id) > 1