Viewing 5 posts - 1 through 5 (of 5 total)
You may want to check out EXCEPT and INTERSECT.
June 9, 2011 at 4:15 pm
Thanks Craig. I needed someone to reassure me that there isn't something obvious I'm missing.
April 19, 2011 at 4:37 pm
ta.bu.shi.da.yu (10/11/2010)
If I read this correctly, you just implemented the LAG(...) Over(...) analytic function.
Cool, I didn't even know this existed. But it looks like it's only available in...
October 11, 2010 at 10:25 am
David McKinney (10/11/2010)
Shouldn't you have a LEFT JOIN rather than an INNER JOIN?
You're right! In haste, I ran an INNER JOIN so that I could just see the compared...
October 11, 2010 at 10:13 am
Viewing 5 posts - 1 through 5 (of 5 total)