Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Comparing Across Records

911624Jan 17 2012 — edited Jan 18 2012
I need to develop a query in PL/SQL where I compare records in a table

The current fields are:

EmplID Effective_Date Department
1 1/1/2011 SALES
1 3/1/2011 SERVICE
1 4/1/2011 SERVICE

...

I need to find out when a particular ID, EmplID has a change in Department, and store that as a field.

Is there an efficient way to do this?

Thanks

Ross
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2012
Added on Jan 17 2012
5 comments
115 views