两种方法

# select device_id,gender,age,university FROM user_profile where age!='';
select device_id,gender,age,university from user_profile where age is not null;