MySQL Query help

Tru Ninja · **Posted:** November 16th, 2012, 8:20 am

Hi guys, I have a problem I can't work out at the moment and I was wondering if someone here could help me. Basically I have a table that has only two columns, ID and Year. I need to select all the IDs from the table where the ID appears in consecutive years.

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 :wink:

reggie · **Posted:** November 23rd, 2012, 11:44 am

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

MySQL Query help

Who is online