空值更新 [英] Upating Null values

问题描述

EMPID分支部
101 A1 101
102 A2 109
103 A3 110
104 A1 NULL
105 A2 89
106 A3 96

我拥有像上表一样的巨大数据，我需要通过从表中选择没有重复项的最大值来更新所有空值

例:A1最大值是101，那么下一个空值应该是102，就像那....

EMPID Branch Dept
101 A1 101
102 A2 109
103 A3 110
104 A1 NULL
105 A2 89
106 A3 96

I hav Huge Data Like Above Table i need to updates all null values BY selecting max value from the table with out duplicates

EXMPLE: A1 max value is 101 then next null value should be 102 like That....

推荐答案

尝试此SQLCOMMAND

TRY THIS SQLCOMMAND

update mytable set dept =(select max(dept) from mytable )+1 where ID= (SELECT MIN(ID) FROM MYTABLE WHERE DEPT IS NULL) AND dept is Null 

在包含空值计数的循环中运行它.

RUN IT IN A LOOP CONTAINING THE COUNT OF THE NULL VALUES.

这篇关于空值更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！