删除带有最后一个时间戳的行

Delete row with last timestamp?

本文关键字：时间戳最后一个删除 | 更新日期: 2023-09-27

我正在尝试使用此 SQL 查询从具有特定成员的行中删除具有最新日期的表的行。

此查询选择要删除的正确行：

SELECT *
FROM Swears
WHERE Date = ( 
  SELECT MAX(DATE) 
  FROM Swears
  WHERE Member = 36)

DELETE
  FROM Swears
  WHERE Date = ( 
    SELECT MAX(DATE) 
    FROM Swears
    WHERE Member = 36)

DELETE
FROM Swears
WHERE Member = 36
ORDER BY Date DESC 
LIMIT 1; -- for the first row

DELETE FROM <table_name>
where <member_column> = <member_value>
ORDER BY Date DESC LIMIT 1