Oracle - Get Data From Past Year (dynamic)

i have some question regarding about get data from database which need to fetch from past year ( dynamic , not hard-coded ) Table: BookingTable bookingID userID Timebooked 1

Solution 1:

You may use sysdate - interval '1' year to represent today's date one year ago:

SELECT userID, COUNT(userID) AS count
FROM BookingTable 
WHERE Timebooked BETWEEN SYSDATE -INTERVAL'1'yearAND SYSDATE
GROUPBY userID
HAVINGCOUNT(userID) >2

As @Wernfried correctly pointed out below, the above would fail for February 29 in a leap year. Instead, use this workaround:

WHERE Timebooked BETWEEN ADD_MONTHS(SYSDATE, -12) AND SYSDATE