jjdhfbu

分类

/ 注册

全部文章（共44篇）

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

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

2023-03-24

0 233

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

select device_id,gender,age,university from user_profile where age is not null 不等于常用"!="而非空使用is not null

2023-03-24

0 249

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

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

2023-03-24

0 218

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

select device_id from user_profile where id<=2 懒惰版

2023-03-24

0 229