Forum Discussion
3 Months rolling query
I have Customer name , Date , ticket_id . I need rolling average of tickets for each customer.
Query require as
*Month over Month
*Rolling 3 month vs. Rolling 3 month
*Current month over same month last year
Regards
Trilok
- Please post table design as DDL, some sample data as DML statement and the expechted result.
