SELECT IN (SELECT, SELECT)

Hello,
I try to extract some datas with SQL request in canvas but I don't find the way to do it with sql restriction essql has (and my poor experience on it).
Here an example of data I have (each row is a document):
contener object
contener1 vase_1
contener1 vase_2
contener1 thing_2
contener1 thing_3
contener2 vase_2
contener2 vase_3
contener2 vase_4
contener2 thing_1
contener2 thing_3

I want the "biggest" object for each contener:
contener1 thing_3
contener2 vase_4
contener2 thing_3

The first thing I tryed is to list objects with the biggest number (vase_4 and thing_3) and then show on wich contener they are.
I can individually find the biggest object for each object name but I can't take them in a list and do a SELECT IN to have the final result.

Anyone know how to do that?
Thanks

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.