Code: Select all
select a.id from `table` as a inner join `table` as b on a.`id` = b.`id` where a.`Year` +1 = b.`Year`
Should work
Statistics: Posted by reggie — November 23rd, 2012, 11:44 am
]]>
So with this sample data:
ID | Year
------------------
1 | 2001
1 | 2002
2 | 2003
2 | 2005
3 | 2006
3 | 2007
I would want to extract 1 and 3. Does this make sense? I can't really think of any other way to describe it, but if you have any questions that could help out please let me know!
tru
Statistics: Posted by Tru Ninja — November 16th, 2012, 8:20 am
]]>