https://leetcode.com/problems/patients-with-a-condition/
Patients With a Condition - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
select patient_id, patient_name, conditions
from Patients
where conditions like 'DIAB1%' or conditions like '% DIAB1%';
728x90
반응형
'자료구조 알고리즘 > 코딩테스트' 카테고리의 다른 글
1795. Rearrange Products Table (0) | 2022.05.30 |
---|---|
1965. Employees With Missing Information (0) | 2022.05.30 |
1484. Group Sold Products By The Date (0) | 2022.05.30 |
1667. Fix Names in a Table (0) | 2022.05.30 |
196. Delete Duplicate Emails (0) | 2022.05.30 |