SELECT * FROM T_TABLE WHERE COL != 'C'
对于COL为null的情况查不出来,需要改为下面的才能查出来:
SELECT * FROM T_TABLE WHERE COL is null OR COL != 'C'
SELECT * FROM T_TABLE WHERE COL != 'C'
对于COL为null的情况查不出来,需要改为下面的才能查出来:
SELECT * FROM T_TABLE WHERE COL is null OR COL != 'C'