Get min date by compare 2 Row
Hi friends,select min(START_DATE,END_DATE) from TABLE1
where (( START_DATE like '%APR%') or (START_DATE like '%MAY%'))
and END_DATE like '%MAY%';
START_DATE END_DATE
------------------ ----------------
29-JAN-16 01-FEB-16
26-FEB-16 29-FEB-16
01-FEB-16 29-FEB-16
In the above table i have to find the Minimum date from the 2 rows, Have to compare the 2 row.
I need the ans as 29-JAN-16,.
Have to do(modify) in the same above Query.
Any Idea?
Thanks in advance.