mysql - 在 SQL 中获取具有唯一目的地的最新数据

Question

我是 MySQL 的新手，我在 mysql 表中有这张表

我怎样才能产生这样的结果？

我想要的是获取具有唯一目的地和年份的最新时间戳。

我试过这个 mysql 查询，但似乎不起作用:

SELECT chp_destination, cde_name, chp_year, chp_from, chp_to, chp_budget_price_high, chp_medium_price_high, chp_luxury_price_high,
    chp_budget_price_low, chp_medium_price_low, chp_luxury_price_low, chp_timestamp, chp_comment, MAX( chp_id ), 
FROM crm_hotel_price
LEFT JOIN crm_destinations ON cde_id = chp_destination
GROUP BY chp_destination, chp_year
ORDER BY chp_id

Answer 1

试试这个:

SELECT * 
FROM (SELECT chp_id, chp_destination, cde_name, chp_year, chp_from, chp_to, chp_budget_price_high, 
                 chp_medium_price_high, chp_luxury_price_high, chp_budget_price_low, chp_medium_price_low, 
                 chp_luxury_price_low, chp_timestamp, chp_comment
        FROM crm_hotel_price
        LEFT JOIN crm_destinations ON cde_id = chp_destination
        ORDER BY chp_destination, chp_year, chp_id DESC) A 
GROUP BY chp_destination, chp_year