写法一:

select device_id,gender,age,university

from user_profile

where not isnull(age)

写法二:

select device_id,gender,age,university

from user_profile

where not  age is null

写法三:

select device_id,gender,age,university

from user_profile

where age is not null