Grouping in Pivot Query | marcia hon | 2018-03-07 10:20 | |||||||||
Status: Closed | |||||||||||
Hello, I have a query, that requires a pivot. However, I am unable to get the group by to work appropriately. My query is: ... 'CYP1A2_rs762551' ) AND D.LabID<100 GROUP BY D.SeriesName, D.LabID, D.CollaboratorSampleID, D.Sex, G.Locus, G.Allele1, G.Allele2 PIVOT Alleles BY Locus ORDER BY SeriesName, LabID, CollaboratorSampleID, Sex ... I would like Group by to work for : D.SeriesName, D.LabID, D.CollaboratorSampleID, D.Sex Not to include Locus, and Allele1/2 I look forward for your insight. |
|||||||||||
| |||||||||||