刷题好难哦
刷题好难哦
全部文章
分类
题解(3)
归档
标签
去牛客网
登录
/
注册
刷题好难哦的博客
全部文章
(共3篇)
题解 | #获得积分最多的人(二)#
select COUNT(distinct device_id) as did_cnt,COUNT(question_id) as question_cnt FROM question_practice_detail where month(date)=8;
Mysql
2021-09-16
0
296
题解 | #查找当前薪水详情以及部门编号dept_no#
SELECT*from (SELECT name,sum(grade_num) as grade_sumFROM user as u join grade_info as g ON u.id=g.user_idGROUP BY user_idorder BY grade_sum DESC) tlim...
2021-09-09
0
211
题解 | #查找当前薪水详情以及部门编号dept_no#
SELECT s.emp_no,s.salary,s.from_date,s.to_date,d.dept_nofrom salaries as s ,dept_manager as dwhere s.emp_no = d.emp_noORDER by s.emp_no; 不太明白为啥要使用内联结,...
2021-08-18
6
272