Toad World® Forums

Record new with exists or count

#1

Hi, how can I know when a record is new per month?
How can I get only the new records per month?

I could use exists or count? I do not know
Maybe another instruction can be used.

#2

The only way you can know if a record is "new" is if there is something in your data to tell you that. Some people like to have a "date added" column in their tables and default it to SYSDATE, for example.