select Batch_Code from MST_BATCH
where batch_end_date <= '2020-03-24' and ScheduleExamDate is null and RequestStatus in(2, 0) and
not batch_code in('BATCH-JH-14063', 'BATCH-JH-14474', 'BATCH-HP-15572', 'BATCH-DL-15794',
'BATCH-DL-15795', 'BATCH-WB-14501', 'BATCH-WB-14502', 'BATCH-RJ-15913','BATCH-AS-17031',
'BATCH-AS-17146', 'BATCH-CG-15425','BATCH-CG-16608', 'BATCH-CG-16601', 'BATCH-HR-17042',
'BATCH-HR-17144', 'BATCH-JH-15607', 'BATCH-MH-15325','BATCH-TS-14671','BATCH-TS-15247-DB',
'BATCH-BR-16142', 'BATCH-MP-15854', 'BATCH-MP-15855')
)
or
SELECT * FROM Geeks WHERE NOT GeekID > 104;
No comments:
Post a Comment