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!

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
My current table data is
I 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

Added on Jul 13 2021

#connection, #oracle, #query, #sql

4 comments

153 views

1 mention