Skip to content Skip to sidebar Skip to footer
Home / Oracle / Sql

Oracle Sql Query - Get Data From Last Week (monday-saturday)

Post a Comment
I'm working on a query that would show data added in last week (always beginning with Monday), from COLUMNNAME, TABLENAME. I also have a column with dates, adddate. It seems not to

Solution 1:

I think your expression needs the current date in it somewhere, such as:

where adddate >= next_day(trunc(sysdate), 'MONDAY') - 14 and
      adddate < next_day(trunc(sysdate), 'MONDAY') - 7

Post a Comment for "Oracle Sql Query - Get Data From Last Week (monday-saturday)"