Advertisement
psi_mmobile

Untitled

Nov 16th, 2020 (edited)
1,142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 96.41 KB | None | 0 0
  1. --WBS_TASK_STRING   ACTIVITY_ID FROM_DATE       TO_DATE         #OCCURENCES
  2. /* SQL STATEMENT
  3. select wbs_task_string, activity_id, from_date,to_date, count(*) occurences from wbs_task
  4. where activity_id is not null
  5. group by wbs_task_string, activity_id, from_date,to_date
  6. having count(*) > 1
  7. order by 1;
  8. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement