Displaying 1 result from an estimated 1 matches for "minofgenotype_id".
Did you mean:
maxofgenotype_id
2006 Dec 31
4
Does SQL group by have a heavy duty equivalent in R
...t numeric. All of my data is character
or factor.
Instead I used RODBC
sqlSave(channel,RawSeq)
to push the table into a Microsoft Access database
Then a sql query, courtesy of the Microsoft Access Query Wizard a la design
mode.
SELECT RawSeq.SAMPLE_ID, RawSeq.ASSAY_ID, Min(RawSeq.GENOTYPE_ID) AS
MinOfGENOTYPE_ID, Max(RawSeq.GENOTYPE_ID) AS MaxOfGENOTYPE_ID, Count(
RawSeq.rownames) AS CountOfrownames
FROM RawSeq
WHERE (((RawSeq.GENOTYPE_ID)<>""))
GROUP BY RawSeq.SAMPLE_ID, RawSeq.ASSAY_ID
ORDER BY Count(RawSeq.rownames) DESC;
This way I could easily use the minimum and maximum values to see...