Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. select empid, emp_name, crt_dt
  2. from table1
  3. where crt_dt >= add_months(current_date(), -24)
  4.  
  5. select empid, emp_name, crt_dt
  6. from table1
  7. where crt_dt > ${last_run_date}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement