Hi,
I need to compare the value of two dates of a same table. These two columns have the same DATE type.
I try to run this statement “SELECT * FROM myTable WHERE date1 <> date2” but it returns also rows with the same value for the two dates (e.g. 01-FEB-05).
How I could writing the right SELECT in order to return the rows with date1 <> date2, please? Thanks