Pergunta de entrevista da empresa Illumina

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