学习生1

分类

/ 注册

全部文章（共175篇）

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

select device_id,gender,age,university from user_profile where age>0;

2024-11-18

0 46

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

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

2024-11-18

0 77

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

select device_id, gender, age from user_profile where age between 20 and 23;

2024-11-18

0 46

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

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

2024-11-18

0 50

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

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

2024-11-18

0 52

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

select device_id as user_infos_example from user_profile where id<=2;

2024-11-18

0 81

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

select device_id from user_profile where id<=2;

2024-11-18

0 64

题解 | #查询结果去重#

select university from user_profile group by university;

2024-11-18

0 60

题解 | #查询多列#

select device_id,gender,age,university from user_profile;

2024-11-18

0 47

题解 | #名单中出现过的人#

import sys a=['Tom','Tony','Allen','Cydin','Lucy','Anna'] q=input() print(tuple(a)) boole=True for i in range(len(a)): if a[i]==q: print(...

2024-11-17

0 55