Finding out erroneous records

From: Sandy80 <>
Date: Mon, 5 May 2008 01:00:26 -0700 (PDT)
Message-ID: <>


I have a table that has sample records like below:

Emp No.		Unique ID		From Date		To Date
11		1234		01-Jan-2005	30-Sep-2005
11		2345		01-Oct-2005	31-Oct-2005
11		3456		01-Nov-2005	31-Oct-2005

The task that I have is to find out records where the From Date is greater than the To Date. This is needed because the 3rd record in the example above is actually an erroneous record which needs to be deleted. The query that I was able to write was returning the 2nd record also because 01-Oct-2005 is greater than 30-Sep-2005. Please help me with the query which would return only the 3rd record.

Any help would be appreciated...thanks!
Sandy Received on Mon May 05 2008 - 03:00:26 CDT

Original text of this message