On 1/19/06 7:14 AM, "Martijn van Oosterhout" wrote:
> On Thu, Jan 19, 2006 at 07:03:47AM -0500, Sean Davis wrote:
>> I have a table that stores data like so:
>
>
>
>> And I would like to design a query that gives:
>>
>> Clone_idx expt_id_1 expt_id_2
>> 1 0.7834 0.8231
On Jan 19, 2006, at 21:03 , Sean Davis wrote:
I have a table that stores data like so:
Create table raw_vals (
expt_id int,
clone_idx int,
val numeric,
primary key (expt_id,clone_idx)
);
And I would like to design a query that gives:
Clone_idx expt_id_1 expt_id_2
1
On Thu, Jan 19, 2006 at 07:03:47AM -0500, Sean Davis wrote:
> I have a table that stores data like so:
> And I would like to design a query that gives:
>
> Clone_idx expt_id_1 expt_id_2
> 1 0.7834 0.8231
> 2 0.2832 1.2783
>
> There are severa
I have a table that stores data like so:
Create table raw_vals (
expt_id int,
clone_idx int,
val numeric,
primary key (expt_id,clone_idx)
);
And I would like to design a query that gives:
Clone_idx expt_id_1 expt_id_2
1 0.7834 0.8231
2 0.28
