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 |