牛客网SQL非技术快速入门

SQL1 查询所有列

SELECT *
FROM user_profile

SQL2 查询多列

SELECT device_id, gender, age, university
FROM user_profile

SQL3 查询结果去重

SELECT DISTINCT university
FROM user_profile

SQL4 查询结果限制返回行数

SELECT device_id
FROM user_profile
LIMIT 2

SQL5 将查询后的列重新命名

SELECT device_id AS user_infors_example
FROM user_profile
LIMIT 2

SQL6 查找学校是北大的学生信息

SELECT device_id, university
FROM user_profile
WHERE university = '北京大学'

SQL7 查找年龄大于24岁的用户信息

SELECT device_id, gender, age, university
FROM user_profile
WHERE age > 24

SQL8 查找某个年龄段的用户信息

SELECT device_id, gender, age
FROM user_profile
WHERE age BETWEEN 20 AND 23

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

SELECT device_id, gender, age, university
FROM user_profile
WHERE university <> '复旦大学'

SQL10 用where过滤空值练习

SELECT device_id, gender, age, university
FROM user_profile
WHERE age IS NOT NULL

SQL11 高级操作符练习(1)

SELECT device_id, gender, age, university, gpa
FROM user_profile
WHERE gender = 'male' AND gpa > 3.5

SQL12 高级操作符练习(2）

SELECT device_id, g