题解 | #用where过滤空值练习#
用where过滤空值练习
http://www.nowcoder.com/practice/08c9846a423540319eea4be44e339e35
题目意义是把age是null值筛选出来。
select
device_id,
gender,
age,
university
from user_profile
WHERE
age is not null
考点is not null 不为空的,那列呢age列(age is not null)
用where过滤空值练习
http://www.nowcoder.com/practice/08c9846a423540319eea4be44e339e35
题目意义是把age是null值筛选出来。
select
device_id,
gender,
age,
university
from user_profile
WHERE
age is not null
考点is not null 不为空的,那列呢age列(age is not null)
相关推荐