Say I have a table with columns C and D (among others but these are the relevant ones) with the date type.
I am instructed to update the values in C to be 90 days before its corresponding value in D, or the current date, whichever is later.
I'm given the hint that it "will be useful to search for the Oracle function that determines the maximum value in a series. Hint: it is not max(), which is an aggregate function!"
I have no idea what this function is and would appreciate any help!