SELECT * FROM tb_table WHERE sample_code IN ( SELECT sample_code FROM tb_table GROUP BY sample_code HAVING COUNT (sample_code) > 1 );