Quick SQL question
I have a table of nominations for lodges that includes a Year field. Any given lodge can be nominated in different years, so will multiple records in this table, e.g.
LodgeID, Year
1, 2015
1, 2014
1, 2013
2, 2015
3, 2015
3, 2013
What would the SQL syntax be to return a list of lodges where the Year included 2015 only?
ie
2, 2015
Thanks.