I have a GMP table, let’s say there are 1000 rows present in the table and 20 columns present as a parameter, lets say 20 row present where parameter1 = x and parameter2 = y and all the other parameter have values also in all the 20 row , what i want a single row where parameter1 = x and parameter2 = y, and the most frequent value of all the other parameters , like param3, param4…param20 where parameter1 is x and parameter2 is y
I want a single row where parameter1 is x and parameter2 is y
3