GROUP BYとMAX関数
例)項目毎の最高値を出し、高い順にソート
SELECT
item_id,
item_name,
max(price) as max_price
FROM
item_tbl
GROUP BY
item_id,item_name
ORDER BY
max_price desc
例)項目毎の最高値を出し、高い順にソート
SELECT
item_id,
item_name,
max(price) as max_price
FROM
item_tbl
GROUP BY
item_id,item_name
ORDER BY
max_price desc