Database

Finding Duplicate Rows

(:source lang=sql :) 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