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