Wilder1626
asked on
Oracle - query to return diffrences
Hi,
I have this table where 3 columns could have same information where the last 4 columns can sometime be the same and other times can have different values.
In below sample that you will also have in the attachment, you see that Brampton John Carson have 3 records but when you look at the columns Result1 to Result4, 2 rows are the same versus the other is different.
As for Ajax Bruce Saxton, Result1 to Result4 have the same values on both rows.
The objective for me is to only extract from the table when i have the same value from City, Name and Family name and when i have more then 1 difference in columns Reult1 to Result4.
Example. If my table got:
The query result would return:
How can i do that?
Thank you for your help
Table1.xlsx
I have this table where 3 columns could have same information where the last 4 columns can sometime be the same and other times can have different values.
In below sample that you will also have in the attachment, you see that Brampton John Carson have 3 records but when you look at the columns Result1 to Result4, 2 rows are the same versus the other is different.
As for Ajax Bruce Saxton, Result1 to Result4 have the same values on both rows.
The objective for me is to only extract from the table when i have the same value from City, Name and Family name and when i have more then 1 difference in columns Reult1 to Result4.
Example. If my table got:
The query result would return:
How can i do that?
Thank you for your help
Table1.xlsx
ASKER
Hi sdstuber,
is it only looking at result4 diffrences or all of the Results 1,2,3 and 4?
is it only looking at result4 diffrences or all of the Results 1,2,3 and 4?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's for your help. this is exactly what i was looking for.
Open in new window