刷题好难哦

题解

/ 注册

全部文章 / 题解（共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 299

题解 | #查找当前薪水详情以及部门编号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 213

题解 | #查找当前薪水详情以及部门编号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 274