반응형
https://leetcode.com/problems/patients-with-a-condition/
📕 풀이방법
📔 정답 출력 | 반환
LIKE절을 사용해 DIAB1으로 시작하는 conditions를 select합니다.
📕 Code
📔 ANSI SQL
SELECT * FROM patients
WHERE conditions LIKE 'DIAB1%' OR conditions LIKE '% DIAB1%';
*더 나은 내용을 위한 지적, 조언은 언제나 환영합니다.
'Algorithm > SQL' 카테고리의 다른 글
(SQL) - LeetCode (easy) 1507. Reformat Date (0) | 2024.04.13 |
---|---|
(SQL) - LeetCode (easy) 1484. Group Sold Products By The Date (0) | 2024.04.02 |
(SQL) - LeetCode (easy) 1251. Average Selling Price (0) | 2023.12.20 |
(SQL) - LeetCode (easy) 1211. Queries Quality and Percentage (2) | 2023.12.06 |
(SQL) - LeetCode (easy) 1148. Article Views I (0) | 2023.11.09 |