Thursday, April 28, 2022

IN and DISTINCT Clause in SQL SERVER

 select  * from mst_batch where batch_end_date < '2020-04-21'  and batch_end_date>'2019-01-01'

and ScheduleExamDate is null and RequestStatus  in(2,  0)

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

select distinct requeststatus from mst_batch

No comments:

Post a Comment