Re: SQL: Displaying rows as column headers help
- From: "Nigel Thomas" <nigel.cl.thomas@xxxxxxxxxxxxxx>
- To: lizzpenaorclgrp@xxxxxxxxx, "Oracle-L List" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Jul 2008 07:50:21 +0100
Laura
select code, col_id, species, fish_id
, case when locus='Omm1080v1' then alleles else null end OMM180V1
, case when locus='Oki10v1' then alleles else null end OKI10V1
... etc - one case expression per column required
from whatever the table name is
(or oldtimers use DECODE instead of CASE)
Regards Nigel
2008/7/24 laura pena <lizzpenaorclgrp@xxxxxxxxx>:
> So I have the following requirement:
>
>
>
> CODE COL_ID SPECIES FISH_ID LOCUS ALLELES
> chintest 11 23220 1 Omm1080v1 252,268
> chintest 11 23220 1 Oki10v1 183,241
> chintest 11 23220 1 christian 252,268
> chintest 11 23220 2 Omm1080v1 256,284
> chintest 11 23220 2 Oke4v1 245,245
> chintest 11 23220 2 Oki10v1 187,225
>
>
> output to look like Locus should be shown columns wise with Alleles under
> the locus name:
> CODE COLID SPE FISH_ID Omm1080v1 Oki10v1 christian Omm1080v1
> Oke4v1
> chintest 11 23220 1 252,268
> chintest 11 23220 1 183,241
> chintest 11 23220 1
> 252,268
> chintest 11 23220
> 2 256,284
> chintest 11 23220
> 2
> 245,245
> chintest 11 23220 2 187,225
>
>
>
>
>
>
>
> Any ideas how to (even a start would be good) write this query? Any help
> is as always appreciated.
>
>
>
> Thanks,
>
> Lizz
>
>
>
>
>
>
Other related posts:
