365 remove duplicate data from the calendar

ITunes-ApplicationProgram-- 365 calendar -- export data opened in navicat mainly because the schedule table first queries the created value of duplicate data. When other values without IDS can be queried, then delete the data.

Note that you must import the data when the 365 calendar app is disabled. You can delete all the data before import. After importing the data, remember to click sync on the left of the app, otherwise, the data on the cloud is not modified, and the data on the old cloud is still synchronized on other devices.

Select title from Schedule where title = 'Evening dinner'

Select min (ID) from Schedule group by title

Delete from Schedule where id not in (select Min (ID) from Schedule group by title );

Delete from Schedule where created not in (select Min (created) from Schedule group by title );