我只想在不使用不同的情况下显示每个主题_id的一行.不知道该怎么做

Question

数据库的outut与大量数据一起工作，因此冻结了数据库

我已经尝试了PGADMIN的独特之处，到目前为止还没有运气。

SELECT p.subject_id,
    p.gender,
    p.dob,
    d.icd9_code, 
    pro.seq_num,
    pro.icd9_code,
    inpc.itemid inputevents,
    inp.itemid inputevents_mv,
    lab.itemid labevents,
    outp.itemid outputevents
FROM mimiciii.patients p
INNER JOIN mimiciii.diagnoses_icd d
    ON p.subject_id = d.subject_id
INNER JOIN mimiciii.procedures_icd pro
    ON p.subject_id = pro.subject_id
INNER JOIN mimiciii.labevents lab
    ON p.subject_id = lab.subject_id
INNER JOIN mimiciii.inputevents_cv inpc
    ON p.subject_id = inpc.subject_id
INNER JOIN mimiciii.inputevents_mv inp
    ON p.subject_id = inp.subject_id
INNER JOIN mimiciii.outputevents outp
    ON p.subject_id = outp.subject_id
WHERE d.icd9_code = '4299'

我不断获得主题的重复值。

Answer 1

输出其正确的输出，因为您对相同的" object_id"有许多" labevents"。

如果要获取所有这些数据，您将始终获得倍数行。

如果您只需"患者"数据，则可以使用子查询，例如存在的副标。

有些喜欢...

SELECT [p...] from patients p where exists (select 1 from ... where p.subject_id=d.subject_id )

=]