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!

Query to get previous days records based on the day of the week

User_6R3DESep 2 2021 — edited Sep 2 2021

I'm a bit of a beginner to Oracle SQL so please forgive me for the terminology. I'm trying filter a on a script that I have already selected the columns. I would like to pull previous days records based on the day of the week. Every day I would like pull yesterday's data except for Monday. Because we are off during the weekend I would like to pull data from Friday thru Sunday only on Monday. I don't know where to start with the script, so any help would be appreciated. Thanks

Comments
Post Details
Added on Sep 2 2021
2 comments
813 views