Handling NULL sets within the SQL CASE statement
Question: I'm trying to write a case statement that will query the maximum date from a table, and if the result is null- return sysdate. select max(case somedate when NULL then sysdate else somedate end) somedate from trydates where somedate < (sysdate-4)...