SQL query to find all specific value in all columns based on row id.
My data looks like this
My question: is there any SQL query which allows us to determine specific column values with respect to the row id? Here I want to know the values of all the columns having AA in row1. I want an output mentioning row id and all columns having AA value.
Any help is highly appreciated.
Best,
• 861 views
•
link
updated
by
Pierre Lindenbaum
•
written
by
lippithakkar •
•
written
by
lippithakkar •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
What may cause my z-score-FDR distribution
written by Pallondyle •
-
How to determine the total count for each gene in lymphotype B
written by dalibenam64 •
-
Why am I getting only one common value when comparing two excel files?
written by namck •
-
Plots for DNA methylation vs Gene Expression
written by sswang25 •
-
How to combine a data frame with another data frame containing comma-separated values?
written by sasa •
-
PLINK ASSOC : Skipping --assoc/--model since less than two phenotypes are present.
written by Michal Nevo •
-
bcftools mpileup giving more wildtypes <*> than expected
written by gt •
-
R script for Gene ID Mapping?
written by shrgur •
-
dpylr filter and for loop
written by siu
-
How to extract rows from data frame with row names in R?
written by blacktomato27
show us the schema for your database