在MySQL中，假设一个表有以下记录:
+---------+-------+-------+
| Item | Price | Brand |
+---------+-------+-------+
| Watch | 100 | abc |
| Watch | 200 | xyz |
| Glasses | 300 | bcd |
| Watch | 500 | def |
| Glasses | 600 | fgh |
+---------+-------+-------+
以下哪项将选择每个项目中价格最高的记录？( )
select item, brand, price from items where max(price) order by item
select * from items where price = max group by item
select item, brand, max(price) from items group by item
select * from items where price > 200 order by item
