这应该给出相同的结果，并且性能要好得多。
SELECt p1.*FROM prod_prices p1 INNER JOIN ( SELECt ID, MAX(Date) AS Date FROM prod_prices GROUP BY ID ) AS p2 ON p1.ID = p2.ID AND p1.Date = p2.Date
这应该给出相同的结果，并且性能要好得多。
SELECt p1.*FROM prod_prices p1 INNER JOIN ( SELECt ID, MAX(Date) AS Date FROM prod_prices GROUP BY ID ) AS p2 ON p1.ID = p2.ID AND p1.Date = p2.Date
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
