Thursday, September 1, 2022

Exclude records from where condition SQL Server

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