勤奋努力的追梦人想要offer
勤奋努力的追梦人想要offer
全部文章
分类
归档
标签
去牛客网
登录
/
注册
勤奋努力的追梦人想要offer的博客
全部文章
(共44篇)
题解 | 分析客户逾期情况
with customer_overdue as( select ct.pay_ability, count(distinct ct.customer_id) as overdue_count from customer_tb ct ...
2025-06-16
0
13
题解 | 最长连续登录天数
with t1 as( select user_id, count(continday) as consec_days from ( select user_id, # data_sub函数 # 用登陆日期-连续递增的数字(排...
2025-06-16
0
11
题解 | 每个月Top3的周杰伦歌曲
WITH PlayStats AS ( SELECT YEAR(pl.fdate) AS year, MONTH(pl.fdate) AS month, si.song_id, si.song_name, ...
2025-06-16
0
19
题解 | 基本数学函数
select id, value, ABS(value) as absolute_value, ceil(value) as ceiling_value, floor(value) as floor_value, round(value,1) as r...
2025-06-16
0
21
题解 | 计算每日累计利润
select dp.profit_id, dp.profit_date, dp.profit, sum(dp.profit) over (order by dp.profit_date)as cumulative_profit from daily_profi...
2025-06-16
0
25
题解 | 电话号码格式校验
select id, name, phone_number from contacts where ( phone_number not like '%-%' and length(phone_number)=10 ...
2025-06-16
0
20
题解 | 21年8月份练题总数
select count(distinct device_id) as did_cnt, count(*) as question_cnt from question_practice_detail where date like '2021-08-%'; 从名为q...
2025-06-16
0
22
题解 | 查找后降序排列
select device_id, gpa, age from user_profile order by gpa desc, age desc; 从名为 “user_profile” 的表中,选取 “device_id”(设备 ID)、“gpa”(...
2025-06-16
0
17
题解 | 查找后多列排序
select device_id, gpa, age from user_profile order by gpa asc, age asc; 从名为user_profile的表中选择device_id(设备 ID)、gpa(平均绩点)和age(年龄)...
2025-06-16
0
22
题解 | 查找后排序
select device_id, age from user_profile order by age ASC; 从名为 “user_profile” 的数据表中,选取 “device_id”(设备标识)和 “age”(年龄)这两列的数据。然后,按照 “age” 列...
2025-06-16
0
20
首页
上一页
1
2
3
4
5
下一页
末页