Redian新闻
>
Help- A simple question about SQL
avatar
Help- A simple question about SQL# Database - 数据库
t*n
1
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!
avatar
T*e
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!

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。