There is a table with gene_ids (‘gid’) and clone_ids (‘cid’). Each
gene only resides on a single clone and each clone may contain multiple
genes. How do you find how many genes are on each and every clone? Thanks!!
1
w*******e 发帖数: 1622
2
Use COUNT
!!
【在 a********y 的大作中提到】 : There is a table with gene_ids (‘gid’) and clone_ids (‘cid’). Each : gene only resides on a single clone and each clone may contain multiple : genes. How do you find how many genes are on each and every clone? Thanks!! : 1
c*****d 发帖数: 6045
3
select count(gid) from table
group by cid
!!
【在 a********y 的大作中提到】 : There is a table with gene_ids (‘gid’) and clone_ids (‘cid’). Each : gene only resides on a single clone and each clone may contain multiple : genes. How do you find how many genes are on each and every clone? Thanks!! : 1
