SQL Case When - I have a column with job status options B & D. I want to create a case when SQL statement that will check and retrieve employee IDs with both statuses in the column. In thise case shown it should only return John Doe, not Doe John or John Jr.

Asked by jones0207
(9 rep)
Jan 24, 2023, 07:55 PM
Last activity: Jan 25, 2023, 08:16 AM
Last activity: Jan 25, 2023, 08:16 AM