Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

First rec of the last group!!!

Thirumoorthy SelvarajJul 13 2021 — edited Jul 13 2021

Hi All
Any help for me to resolve this issue will be greatly appreciated.
I have data like this below
My history table data looks like
image.pngMy current table data is
image.pngI need the SQL output that has Add date of 8/1/2020 (SNO : 6). I have RecVal and IND to match and use change_date to start my search from my current table data for the RecVal..
I need to search from the bottom of my history list and get to data that has same RecVal and IND of my current table record and get the minimum add_date based on my change_date.
I dont want history records 1 or 2 based on RecVal and IND

This post has been answered by mathguy on Jul 14 2021
Jump to Answer

Comments

Post Details

Added on Jul 13 2021
4 comments
150 views