Group By max SQL

 SELECT cate_id, MAX( book_price)

FROM book_mast GROUP BY cate_id;

reference:- https://www.w3resource.com/mysql/aggregate-functions-and-grouping/aggregate-functions-and-grouping-max-with-group-by.php