Could anyone help me for the following question?
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? Please provide the
SQL.
Many thanks!
T*****e 发帖数: 361
2
select cid, count(*) from t?
gene
How
【在 t****n 的大作中提到】 : Could anyone help me for the following question? : 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? Please provide the : SQL. : Many thanks!
