반응형
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) 1731. The Number of Employees Which Report to Each Employee (0) | 2024.06.26 |
---|---|
(C++) - LeetCode (easy) 1633. Percentage of Users Attended a Contest (0) | 2024.05.16 |
(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 |