Using an Exclusive Join to get the Last Item of a Group Print

Example Table

id | item | value
1  | 5    |  1
2  | 5    |  2
3  | 5    |  8
4  | 6    |  5
5  | 6    |  8

Query to select the Lowest Value

SELECT t1.*
FROM `table` AS `t1`
LEFT JOIN `table` AS `t2` ON `t1`.`id` = `t2`.`id` AND `t1`.`value` > `t2`.`value`
WHERE `t2`.`id` IS NULL

Query Result

id | item | value
3  | 5    |  8
5  | 6    |  8

Query to select the Highest Value (Change the Operator)

SELECT t1.*
FROM `table` AS `t1`
LEFT JOIN `table` AS `t2` ON `t1`.`id` = `t2`.`id` AND `t1`.`value` < `t2`.`value`
WHERE `t2`.`id` IS NULL

Query Result

id | item | value
3  | 5    |  8
5  | 6    |  8