I need a little help with a query .
I have attached an example table (roughly) in attached picture. The table has a serial number, a supplier_id and a weight column.
We need to retrieve FOR each supplier the row that has maximum weight. There could be duplicate rows if the maximum weight for a supplier is same in two rows. I have written the expected output in the excel file as well.
Your help would really be appreciated.