Good afternoon, all.
I'll start with giving you an example of a table I'm working with:
NUM NUM2 YR 987654321 L77796 2004 987654321 L77796 2005 987654321 NULL 2006 987555433 L22284 2004 987555433 L22284 2005 987555433 NULL 2006 217864444 T22244 2007 217864444 T22244 2008 217864444 NULL 2012
I'm drawing a total blank here -- how would I go about finding all the NUM's whose NUM2 value for the latest YR does not equal the NUM2 value for the year preceding?
What I'm trying to accomplish to to get the NUM2 to be the same for each NUM across all YR, but I'd like to see how many will be affected first by running a SELECT.
Sorry if this is clear as mud!.