SELECT device_id, gender, age, university FROM user_profile WHERE age is not null and age > 24
null 是大于所有数值型还是小于所有数值型是由 DBMS 决定的,严谨起见,还是加上 age is not null 的条件
SELECT device_id, gender, age, university FROM user_profile WHERE age is not null and age > 24
null 是大于所有数值型还是小于所有数值型是由 DBMS 决定的,严谨起见,还是加上 age is not null 的条件