如果一个病人来医院3次，有一次出院状态是死亡，2次是存活.我想写一个代码，在所有的访问，如果状态是死亡，那么最终的状态应该是死亡.
| PatientName | PatientVisit | DischargeStatus | FinalStatus |
|---|---|---|---|
| A | 1 | Survived | Survived |
| A | 2 | Survived | Survived |
| A | 3 | Survived | Survived |
| B | 1 | Died | Died |
| B | 2 | Survived | Died |
谢谢.
如果一个病人来医院3次，有一次出院状态是死亡，2次是存活.我想写一个代码，在所有的访问，如果状态是死亡，那么最终的状态应该是死亡.
| PatientName | PatientVisit | DischargeStatus | FinalStatus |
|---|---|---|---|
| A | 1 | Survived | Survived |
| A | 2 | Survived | Survived |
| A | 3 | Survived | Survived |
| B | 1 | Died | Died |
| B | 2 | Survived | Died |
谢谢.
根据我有限的SQL经验，我认为你应该这样做:
UPDATE Patient SET FinalStatus = 'Died' WHERE PatientName in (SELECT name FROM (SELECT PatientName AS name FROM Patient WHERE DischargeStatus = 'Died') AS a);个
因为我们不能在FROM子句中为UPDATE指定目标表‘Patient’，所以我在这里添加了一个内部表‘a’.