kuroの覚え書き

96の個人的覚え書き

GROUP BY でSELECTしてJOINしてSELECT

SELECT exome171001.variant_id, var_count.variant_count from exome171001 LEFT OUTER JOIN 
    (SELECT pos, REF, ALT, COUNT(*) as variant_count from exome171001 GROUP BY pos, REF, ALT) AS var_count
     ON exome171001.pos=var_count.pos and exome171001.REF=var_count.REF and exome171001.ALT=var_count.ALT;