A SQL question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

A SQL question

A SQL question# Database - 数据库

a*y2006-10-30 08:10

1 楼

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*e2006-10-30 08:10

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