Imagine data as below:- category_id item_name 1 Item A1 1 Item A2 1 Item A2 2 Item B1 2 Item B1 2 Item B2 3 Item C1 3 Item C2 In this query: Now, let’s see the result of executing this modified query on our sample data: category_id item_name displayOrder 1 Item A1 1 1 […]