SQL9、查找除复旦大学的用户信息

思路:使用WHERE关键字添加限定条件,并且注意用 NOT关键字过滤掉复旦大学的用户

代码解释:从表user_profile中取出列device_idgenderageuniversity,并排除复旦大学用户

SELECT
  device_id,
  gender,
  age,
  university
FROM
  user_profile
WHERE
  NOT(university = '复旦大学')

题目:https://www.nowcoder.com/practice/c12a056497404d1ea782308a7b821f9c?tpId=199&tqId=1971604&ru=/exam/oj&qru=/ta/sql-quick-study/question-ranking&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D199

posted @ 2022-07-11 00:40  tiansz  阅读(39)  评论(0编辑  收藏  举报