I have a table in Db2 called myTable.
It has several columns:
a | b | date1 | date2
---------------------------------------------
1 abc 2014-09-02
2 aax 2015-12-30 2016-09-02
2 bax 2015-10-20
2 ayx 2014-12-10 2016-02-12
As seen from values above, date1 and date2 can have null values as well.
How can I get the max of both date1 and date2 together ?
i.e. the output of the query should be 2016-09-02 as that is the max date of all the dates present in date1 and date2.
I am using Db2-9.
Thanks for reading!
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)