Skip to content
Advertisement

Joining two tables using left outer join and population a new column values based on the right table column

I have two tables exam_table and emp_table, Here i would like to join both tables using left outer join and I want to create a new column called new_column using exam_completed_date column from the right table.

I need output like this

Advertisement

Answer

I think you want a cumulative max window function:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement