天上飞的云传奇

分类

面试题(2) 题解(18)

/ 注册

全部文章（共18篇）

题解 | #汇总各个部门当前员工的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

题解 | #求平方根# Java 可通过二分法

import java.util.*; public class Solution { /** * * @param x int整型 * @return int整型 */ public int mysqrt (int x) { if(x==0) return 0; if(x<4) return...

Java

2021-11-30

0 301

题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

运行时间60ms Select distinct dept_no,dept_name,title, (select count(title) from titles t1 where emp_no in (select emp_no from dept_emp de1 where de1.dep...

2021-07-29

0 344

题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

select de.emp_no ,dm.emp_no as manager_no, salary AS emp_salary,(select salary from salaries where emp_no = dm.emp_no) as manager_salaryfrom dept_emp ...

2021-07-26

0 356

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

SELECT dept_no,dept_name,(select count(sa.emp_no) from salaries sa where &...

2021-07-25

0 363

题解 | #获取所有员工当前的manager#

select emp_no , (select emp_no from dept_manager dm where dm.dept_no = de.dept_no) as manager from dept_emp de where not exists (select 1 from dept_ma...

2021-07-25

1 307

题解 | #获得积分最多的人(一)#

select u.name,sum(gr.grade_num) as grade_num from user u join grade_info gr on u.id = gr.user_id group by gr.user_id order by grade_num desc limit 0,1

2021-07-25

0 377