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!

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

Yes, you can connect to Oracle Database 12.2 using node-oracledb.

Note if you are using the Exadata Express Cloud Service, grab the updated Instant Client: http://www-content.oracle.com/technetwork/database/database-technologies/scripting-languages/cloud-3080568.html

1 - 1

Post Details

Added on Jul 13 2021
4 comments
154 views