实现方法:
- where col_name is not null
- where col_name != ‘null’
- where col_name <> ‘null’
exp:
代码实现:
--方法一 注意null加引号
select device_id , gender , age , university
from user_profile
where age != 'null'
--方法二 注意null加引号
select device_id , gender , age , university
from user_profile
where age <> 'null'
--方法三
select device_id , gender , age , university
from user_profile
where age is not null