Hi Team,
I have an Employee table in below structure, and I want to create a list of years by taking all the distinct years from both the Start_Date and End_Date columns.
employee ( emp_id Number, Start_Date Date, End_Date Date, Status Varchar2(50) )
Please help me with your ideas.
Discussion posts and replies are publicly visible