GB279824

分类

/ 注册

全部文章（共190篇）

题解 | 计算每日累计利润

select *, sum(profit) over (order by profit_date) as cumulative_profit from daily_profits order by profit_date ASC SUM(profit): 表示对 profit 列的值进行求和操作。O...

2025-05-16

0 37

题解 | 电话号码格式校验

select * from contacts where phone_number regexp '^[1-9][0-9]{9}$|^[1-9][0-9]{2}-[0-9]{3}-[0-9]{4}$' order by id ASC '^[1-9][0-9]{9}$|^[1-9][0-9]{2}-[...

2025-05-16

5 38

题解 | 查找GPA最高值

select round(max(gpa),1) as gpa from user_profile where university = '复旦大学'

2025-05-15

0 30

题解 | 查看学校名称中含北京的用户

select device_id, age, university from user_profile where university like '%北京%'

2025-05-15

0 26

题解 | 操作符混合运用

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

2025-05-15

0 32

题解 | Where in 和Not in

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

2025-05-15

0 30

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

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

2025-05-15

0 28

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

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

2025-05-15

0 26

题解 | 用where过滤空值练习

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

2025-05-15

0 33

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

select device_id, gender, age, university from user_profile where university not in ("复旦大学")

2025-05-15

0 29