Suppose we are insrting and deleting and update no of record in teradata in a day but i want only last one hour transation what we did?
what is the query for taht?
You need to check the DBQL Log tables, they track the SQLs that has been executed on the system and you can put a filter on the user for which you want to see the results.
WHERE COLLECTTIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '1' HOUR
AND USER_ID = '<<USER_ID>>'