SQL9 - 查找除复旦大学的用户信息 - NOT IN("")和<>等用法
题目链接
题解
SELECT device_id, gender, age, university
FROM user_profile
WHERE university != "复旦大学"
# Or
-- WHERE university NOT IN ("复旦大学")
-- re university <> "复旦大学"
-- where university != '复旦大学'
-- where not university = '复旦大学'
-- here university NOT IN('复旦大学')
-- where university NOT LIKE '复旦大学'
