Illumina Interview Question

SQL questions on self-join, group by, having clause like how do you retrieve duplicate rows?