我有这个查询:
SELECT NAME, date, price
FROM purchase
WHERE Max(date) < '$lastweek'
AND NAME = '$customer'
GROUP BY NAME;
查询将如何查找最近的日期并将该日期与给定日期进行检查?
你可以
这样尝试:
SELECT NAME, date, price
FROM purchase
WHERE (SELECT Max(date) FROM purchase) < '$lastweek'
AND NAME = '$customer'
GROUP BY NAME;
您是否尝试将购买SELECT MAX(date)
作为子查询?
SELECT NAME, date, price
FROM purchase
WHERE (SELECT Max(date)) < $lastweek
你可以这样做:
SELECT name, MAX(date) as latest_date, price
FROM purchase
WHERE name= '$customer'
GROUP BY name HAVING latest_date = '$date';