表A
ID value1 value2 value3
1 null 3 1
2 2 2 null
3 3 null null
4 null null null
....
如何删除value1到3都为空值的行?
得到:
ID value1 value2 value3
1 null 3 1
2 2 2 null
3 3 null null
....
ID value1 value2 value3
1 null 3 1
2 2 2 null
3 3 null null
4 null null null
....
如何删除value1到3都为空值的行?
得到:
ID value1 value2 value3
1 null 3 1
2 2 2 null
3 3 null null
....
where value1 is null and value2 is null and value3 is null
where value1 is null and value2 is null and value3 is null
where value1='' and value2='' and value3=''