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.