Illumina interview question

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