天上飞的云传奇

分类

面试题(2) 题解(18)

/ 注册

全部文章（共3篇）

题解 | #得分不小于平均分的最低分#

select score from exam_record where exam_id in (select exam_id from examination_info where tag = 'SQL') and score >= (select avg(score) from exam_...

Mysql

2022-02-14

0 336

题解 | #汇总各个部门当前员工的title类型的分配数目#

没用group by select distinct de.dept_no , dep.dept_name , t.title , (select count(title) from titles t1 where ...

Mysql

2021-12-18

0 325

题解 | #统计各个部门的工资记录数#

select de.dept_no,de.dept_name, (select count(*) from salaries s2 where s2.emp_no in (select emp_no from dept_emp d2 where d2.dept_no = d1.dept_no)) f...

Mysql

2021-12-18

0 262