[thelist] SQL Challenge Question

Jay Blanchard jay.blanchard at niicommunications.com
Tue Oct 28 07:43:42 CST 2003

I've got an SQL Challenge for you.

	Given: Two nearly Identical Rows
	Problem: Isolate the columns where the data
		   is not the same.
	Solution: ?

Can this be done? If so, how?

Cannot really be done in SQL in one shot, but you could do it
programmatically. For each column SELECT DISTINCT(foo) and compare each
value in the column with the previous  value in the column, especially
if you have many rows and columns to check.

More information about the thelist mailing list