Sorting + "selecting non-Repeated Records" (3) -- maximum value record

Sorting + "selecting non-Repeated Records" (3) -- maximum value record

Key design points: sorting, filtering, and selecting non-Repeated Records

Xiuxiu: I understand that "No repeated records are selected,

Ajin: What should I do if I want to extract the item with the maximum inventory of each category?

Xiuxiu: Sort the inventory quantity in descending order.

Ajin: Oh? I really understand.

Xiuxiu: Of course! Not only do you understand, but I will also summarize it,

Ajin: Again?

Xiuxiu: In fact, records of the same category and name are put together in order, and then the top record is put forward using "select not repeated records.

Ajin: Ah, "show total" is "show total". The summary is very fast.