「SQL面试题库」 No_120 Patients With a Condition

今日真题

题目介绍： Patients With a Condition patients-with-a-condition

难度简单

SQL架构

Table:

代码语言：javascript复制

Patients

代码语言：javascript复制

 -------------- --------- 
| Column Name  | Type    |
 -------------- --------- 
| patient_id   | int     |
| patient_name | varchar |
| conditions   | varchar |
 -------------- --------- 
patient_id is the primary key for this table.
'conditions' contains 0 or more code separated by spaces. 
This table contains information of the patients in the hospital.

Write an SQL query to report the patient_id, patient_name all conditions of patients who have Type I Diabetes. Type I Diabetes always starts with

代码语言：javascript复制

DIAB1

prefix

Return the result table in any order.

The query result format is in the following example.

``` Patients ------------ -------------- -------------- | patient_id | patient_name | conditions | ------------ -------------- -------------- | 1 | Daniel | YFEV COUGH | | 2 | Alice | | | 3 | Bob | DIAB100 MYOP | | 4 | George | ACNE DIAB100 | | 5 | Alain | DIAB201 | ------------ -------------- --------------

Result table: ------------ -------------- -------------- | patient_id | patient_name | conditions | ------------ -------------- -------------- | 3 | Bob | DIAB100 MYOP | | 4 | George | ACNE DIAB100 | ------------ -------------- -------------- Bob and George both have a condition that starts with DIAB1. ```

代码语言：javascript复制

sql
select  patient_id , patient_name ,conditions 
from Patients
where conditions like '%DIAB1%'

• 已经有灵感了？在评论区写下你的思路吧！

sql contains table varchar 架构

0 人点赞