I am trying to write a query that will return the last friday of the previous month but I am running into the issue of trying to use Current_Date along with Last_Date. I need to use
SELECT CURRENT_DATE from dual no matter what. This is what I have so far, any help would be greatly appreciated as I am new to this.
where (LAST_DAY( SYSDATE ) - INTERVAL '7' DAY,