Dynamic month selection a/c to me is not possible in a select query. Closest I can get to the desired result is : I can set null values to the months out of range. Lets say I can last 3 month data. CREATE TABLE SALES ( DEPT NUMBER, JAN NUMBER,FEB NUMBER, MAR NUMBER,APR NUMBER,MAY NUMBER,JUN NUMBER); INSERT INTO SALES…