Want to purge 3 months old data from database

First you need to decide against which condition you want your purging solution to have established. If you have any other significant value which makes sense to run the cleanup, you can do so.

Sana Khan7y ago

When running your given query it is giving error as below

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '('.

Below is my query

select * from VisaApp where id in ((SELECT id FROM VisaApp) - (SELECT id

AS TIMESTAMP (SYSTIMESTAMP- INTERVAL '3' MONTH))) FROM VisaApp

is rowid will be Id column of table.I am using sql server so i think the SYSTIMESTAMP is not working in it

Prakash Kumar7y ago

Hi Sana Khan,

Use the below query

select * from table where rowid in (

SELECT rowid FROM table

MINUS

SELECT rowid

AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '3' MONTH));

FROM table