SQL Where with not in - where with in - where with more than one records

 select * from MST_BATCH 

where batch_code not in('BATCH-JH-14063', 'BATCH-JH-14474')

---------------

select yearof from MST_BATCH where yearof in ('2014-2015','2015-2016','2016-2017','2017-2018')

-------------------

select * from MST_BATCH 

where batch_code not in('BATCH-JH-14063', 'BATCH-JH-14474')