Good day. can someone help me to achieve on the below output.. I hav a table and I need to pick the row corresponding to the max. value of another column in the same table. input: namesubjectpercentagealexenglish60 maths70 science80richardenglish55 history86 geography90 output: alexscience80richardgeography90

Pick the row. with max value of another column

Good day. can someone help me to achieve on the below output.. I hav a table and I need to pick the row corresponding to the max. value of another column in the same table.

input:

name	subject	percentage
alex	english	60
	maths	70
	science	80
richard	english	55
	history	86
	geography	90

output:

alex	science	80
richard	geography	90

Topic of Interest

Accepted answers

Emil_Kos

Hi @SrinivasanSugumaran,

So first we need to get the data in a proper structure. I have made a name column populated for all the rows. Afterwards, we need to sort the percentages from the highest to lowest and use the sample function to get the desired results: