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!

oracle sql question, rows between preceding

coder112a2Nov 6 2018 — edited Nov 6 2018

I need help understanding the below part of an Oracle SQL query. What does BETWEEN 7 PRECEDING AND 7 PRECEDING do? I understand that a vehicle can have more than one repo date if repo-ed more than once per that account. However, this code is building repo dates 1-7 like this and I am not sure what this is doing exactly. If someone could please explain, much appreciated. Thank you

    , MIN(D0AL1.CONFIRM_DATE) OVER (PARTITION BY D0AL2.ACCOUNT_NBR

    ORDER BY D0AL1.ASSIGNMENT_DATE ROWS BETWEEN 7 PRECEDING AND 7 PRECEDING) AS repo_date1

    , MIN(D0AL1.CONFIRM_DATE) OVER (PARTITION BY D0AL2.ACCOUNT_NBR

    ORDER BY D0AL1.ASSIGNMENT_DATE ROWS BETWEEN 6 PRECEDING AND 6 PRECEDING) AS repo_date2

    , MIN(D0AL1.CONFIRM_DATE) OVER (PARTITION BY D0AL2.ACCOUNT_NBR

    ORDER BY D0AL1.ASSIGNMENT_DATE ROWS BETWEEN 5 PRECEDING AND 5 PRECEDING) AS repo_date3

Comments
Post Details
Added on Nov 6 2018
3 comments
461 views