题解 | #查找除复旦大学的用户信息#
查找除复旦大学的用户信息
http://www.nowcoder.com/practice/c12a056497404d1ea782308a7b821f9c
四种方法
- ！=
- <>
- not in
- not like
## select device_id,gender,age,university from user_profile where university !='复旦大学';
## SELECT device_id,gender,age,university from user_profile where university <> '复旦大学';
## SELECT device_id,gender,age,university from user_profile where university not in ('复旦大学');
SELECT device_id,gender,age,university from user_profile where university not like '%复旦%';
