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'