梓林小朋友

分类

/ 注册

全部文章（共16篇）

题解 | #操作符混合运用#

select device_id,gender,age,university,gpa from user_profile where (gpa>3.5 and university='山东大学') or (gpa>3.8 and university='复旦大学')

2023-04-24

1 170

题解 | #Where in 和Not in#

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

2023-04-24

1 178

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

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

2023-04-24

1 243

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

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

2023-04-24

1 167

题解 | #用where过滤空值练习#

select device_id,gender,age,university from user_profile where age != ' '; # 或者是is not null # where age is not null;

2023-04-24

1 167

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

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

2023-04-24

1 195

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt, count(question_id) as question_cnt from question_practice_detail where date like "2021-08%"

2023-04-24

6 180

题解 | #查找后降序排列#

select device_id,gpa,age from user_profile order by gpa desc,age desc

2023-04-24

1 222

题解 | #查找后多列排序#

select device_id,gpa,age from user_profile order by gpa asc, age asc # asc 升序排列 # desc 降序排列

2023-04-24

1 186

题解 | #查找后排序#

select device_id,age from user_profile order by age

2023-04-24

1 240