作者:敏捷的敏2502921017 | 来源:互联网 | 2023-07-31 10:25
Ineedtodeletealldatesfromdatabaseexceptfirsttwoselecteddates:除前两个选定日期外,我需要删除数据库中的所有日期:
I need to delete all dates from database except first two selected dates:
除前两个选定日期外,我需要删除数据库中的所有日期:
SELECT DateColumn
FROM Table
GROUP BY date(DateColumn)
ORDER BY DateColumn DESC
I want in one query to delete all dates except first two.
我希望在一个查询中删除除前两个日期之外的所有日期。
2 个解决方案