Sample Header Ad - 728x90

SQL multiple condition case when

0 votes
2 answers
196 views
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. enter image description here
Asked by jones0207 (9 rep)
Jan 24, 2023, 07:55 PM
Last activity: Jan 25, 2023, 08:16 AM