人要学会珍惜

题解

/ 注册

全部文章 / 题解（共4篇）

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

select device_id,gender,age,university,gpa from user_profile where gpa>3.7&nbs***bsp;university="北京大学";

Mysql

2022-05-01

0 0

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

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

Mysql

2022-05-01

1 304

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

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

Mysql

2022-05-01

0 290

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

select device_id,gender,age,university from user_profile where university<>"复旦大学";

Mysql

2022-05-01

0 357