select * from tblname where CRO = '00000645'
Acc_ID EndDate CRO EntryDate
3927175 2009-12-31 00:00:00.000 00000645 2010-11-16 00:00:00.000
5859809 2008-12-31 00:00:00.000 00000645 2009-10-09 00:00:00.000
6000968 2010-12-31 00:00:00.000 00000645 2011-09-23 00:00:00.000
8963188 2011-12-31 00:00:00.000 00000645 2012-12-04 00:00:00.000
11309851 2012-12-31 00:00:00.000 00000645 2013-10-23 00:00:00.000
14154225 2013-12-31 00:00:00.000 00000645 2014-11-13 00:00:00.000
14301133 2013-12-31 00:00:00.000 00000645 2014-12-03
i want to get the ID which does not belong to last 3 years i.e(2013, 2012, 2011)
If co changes the value also change. 00000645 is CRO
I am sorry, the table didnt come in proper manner.