var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: can some write a query?
There is a table with veg_ids (‘vid’) and fru_ids (‘fid’). 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?
Seeking a developer? Maybe you should also tell how much the job pays.
post what you have attempted already
select cid,count(*) as 'count'
from #mytable group by cid
post the DDL of your table
create table #mytable (gid int, cid int)
create unique index ix1 on #mytable(gid)
some sample data,
insert into #mytable select
1,1 union all select
2,3 union all select
3,1 union all select
4,1 union all select
5,2 union all select
And the expected results