SQL查询：诊断类型与年龄筛选及基因表达分析.pdfVIP

SELECTno1

FROMdiagnosis

WHEREtype=Nandage=55;

SELECTgpl570.gene_symbol,mrna.g1,mrna.g2,mrna.g3,mrna.g6,mrna.g8,mrna.g10,

mrna.g11

FROMgpl570,mrna,pathway

WHERE(mrna.g1+mrna.g2+mrna.g3+mrna.g6+mrna.g8+mrna.g10+mrna.g11)/7=10and

gpl570.id=mrna.id_refandinstr(pathway.genes,gpl570.gene_symbol)0and

pathway.path=Apoptosis;

SELECTno1

FROMdiagnosis

WHEREtype=Tandage=20-35

SELECTgpl570.gene_symbol,mrna.g104,mrna.g105,mrna.g106,mrna.g107,mrna.g108,

mrna.g109

FROMgpl570,mrna,pathway

WHERE(mrna.g104+mrna.g105+mrna.g106+mrna.g107+mrna.g108+mrna.g109)/6=10and

gpl570.id=mrna.id_refandinstr(pathway.genes,gpl570.gene_symbol)0and

pathway.path=Apoptosis;