Differing values for the same policy numbers.
Posted on 2014-12-17
Have a table with field 'Policy_numbers' There are many 'Policy_numbers' that are repeated multiple times.
There is also a row called 'Commission_rate'. Most of the fields that have the same Policy_number have the
same value for Commission_rate. But would like to test to see any of the rows that have the same Policy_number have more than one Commission_rate.
I think that the comparison could be done with Group by or Having Query but not sure about the syntax.
Allen in Dallas