데이터 분석 기술 블로그

Patients With a Condition _ Easy. LeetCode 본문

SQL/문제풀이

Patients With a Condition _ Easy. LeetCode

데이터분석가 이채은 2025. 1. 12. 19:06 

SELECT patient_id,patient_name,conditions from Patients
WHERE conditions LIKE 'DIAB1%'  OR  conditions LIKE '% DIAB1%' ;

생각해 보면 쉬운 문제인데 LIKE를 생각해내지 못했다.

'SQL > 문제풀이' 카테고리의 다른 글

Delete Duplicate Emails _ Easy. LeetCode  (0) 2025.01.11
Group Sold Products By The Date _ Medium. LeetCode  (0) 2025.01.10
Find Users With Valid E-Mails _ Easy. LeetCode  (0) 2025.01.09
Last Person to Fit in the Bus _ Medium. LeetCode  (0) 2025.01.08
Confirmation Rate _ Medium. LeetCode  (0) 2025.01.07
'SQL/문제풀이' Related Articles more