爆栈炸死各位爷
爆栈炸死各位爷
全部文章
分类
归档
标签
去牛客网
登录
/
注册
爆栈炸死各位爷的博客
全部文章
(共46篇)
题解 | #查询在pc上投递的所有投递记录#
select * from deliver_record_detail where device = 'pc'
2023-11-10
0
78
题解 | #查询表总行数#
select count(*) cnt from deliver_record
2023-11-10
0
73
题解 | #将查询列重新命名#
select job_salary '职位工资' from deliver_record
2023-11-10
0
87
题解 | #查询限制行数#
select * from deliver_record limit 2
2023-11-10
0
70
题解 | #查询所有投递用户user_id并去重#
select DISTINCT user_id from deliver_record
2023-11-10
0
83
题解 | #大小写混乱时的筛选统计#
WITH t_tag_count AS ( SELECT ei.tag, count(*) answer_cnt FROM exam_record er LEFT ...
2023-11-10
0
62
题解 | #对过长的昵称截取处理#
SELECT uid, CASE WHEN CHAR_LENGTH(nick_name) <= 13 THEN nick_name ELSE CONCAT (LEFT (nick_name, 10), '...') END AS nick...
2023-11-10
0
64
题解 | #注册当天就完成了试卷的名单第三页#
SELECT user_info.uid, user_info.level, user_info.register_time, sb.max_score FROM user_info LEFT JOIN ( SELECT ...
2023-11-10
0
67
题解 | #各用户等级的不同得分表现占比#
WITH tmp_user_level AS ( SELECT ui.level, CASE WHEN er.score >= 90 THEN '优' WHEN er.score >= 75 THEN '良' WHEN er.score >...
2023-11-09
0
62
题解 | #根据指定记录是否存在输出不同情况#
WITH user_info_tmp AS ( SELECT ui.uid, ui.level level, SUM( IF ( e...
2023-11-09
1
62
首页
上一页
1
2
3
4
5
下一页
末页