SQL 문제 13 - Patients With a Condition LeetCode 1527

SQL 문제 13 - Patients With a Condition LeetCode 1527 Patients With a Condition 풀이 -- ORACLE, MYSQL SELECT PATIENT_ID , PATIENT_NAME , CONDITIONS FROM PATIENTS WHERE REGEXP_LIKE(CONDITIONS,'^DIAB1|^* DIAB1'); -- MSSQL SELECT PATIENT_ID , PATIENT_NAME , CONDITIONS FROM PATIENTS WHERE CONDITIONS LIKE 'DIAB1%' OR CONDITIONS LIKE '% DIAB1%'; - 오라클과 MYSQL에선 REGEXP_LIKE를 이용하여 풀었으나,, - MSSQL에선 지원하지 않아서 LIKE 문으로 따로 작성하였다. * 출처 Level up your coding skills and quickly land a job. This is the best place to e...

원문링크 : SQL 문제 13 - Patients With a Condition LeetCode 1527