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!

Sql query to track history of Customer based on date field

srikanth bApr 18 2023

CUSTID CITY UPDATE_DT

101 Wisconsin 2022-03-21

101 Philadelphia 2022-09-19

101 Washington 2023-03-17

102 Delaware 2022-01-02

102 Texas 2022-08-02

103 Atlanta 2022-01-02

o/p:

CUSTID CITY UPDATE_DT

101 Washington 2023-03-17

102 Texas 2022-08-02

103 Atlanta 2022-01-02

This post has been answered by Barbara Boehmer on Apr 18 2023

Jump to Answer

Added on Apr 18 2023

#pl-sql

5 comments

320 views