my data set is as follows
| ID | EndDate|
| —| ——–
| 1 | 12/31/2023
| 1 | 12/30/2023
| 1 | 12/29/2023
| 2 | 12/29/2023
| 2 | 12/29/2023
| 2 | NULL
From this data set, I only want to get the record with ID 1 since all the records have ENDDATE not null and is less than ‘1.1.2924’. I will not want ID 2 in my results since one of the records with ID 2 has ENDDATE = null
New contributor
Vandana Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.