CARLJOSEPHLEE

分类

题解(26)

/ 注册

全部文章（共225篇）

题解 | Where in 和Not in

select device_id,gender,age,university,gpa from user_profile where university in ("北京大学","复旦大学","山东大学")

2025-07-18

1 85

题解 | 高级操作符练习(2）

select device_id,gender,age,university,gpa from user_profile where university = "北京大学" or gpa > 3.7

2025-07-18

1 80

题解 | 高级操作符练习(1)

select device_id,gender,age,university,gpa from user_profile where gender = "male" and gpa > "3.5"

2025-07-18

1 91

题解 | 用where过滤空值练习

select device_id,gender,age,university from user_profile where age is not null

2025-07-18

1 97

题解 | 查找除复旦大学的用户信息

select device_id,gender,age,university from user_profile where university != "复旦大学"

2025-07-18

1 90

题解 | 查找某个年龄段的用户信息

select device_id,gender,age from user_profile where 20<=age and age<=23

2025-07-18

1 76

题解 | 查找年龄大于24岁的用户信息

select device_id,gender,age,university from user_profile where age > 24

2025-07-18

1 74

题解 | 查找学校是北大的学生信息

select device_id,university from user_profile where university = "北京大学"

2025-07-18

1 56

题解 | 将查询后的列重新命名

select device_id user_infos_example from user_profile limit 2

2025-07-18

1 72

题解 | 查询结果限制返回行数

select device_id from user_profile limit 2

2025-07-18

1 59