wzying

分类

/ 注册

全部文章（共34篇）

题解 | #实习广场投递简历分析(一)#

select job,sum(num) cnt from resume_info where date like '2025%' group by job order by cnt desc;

2023-03-21

0 250

题解 | #牛客的课程订单分析(一)#

select * from order_info where status='completed' and (product_name='C++'or product_name='JAVA' OR product_name='Python') and da...

2023-03-21

0 182

题解 | #将employees表的所有员工的name拼接#

select concat(last_name,' ',first_name) Name from employees order by emp_no;

2023-03-20

1 247

题解 | #查找所有员工的name和及dept_name#

#先做门员工关系表 #在做员工姓名跟部门关系表 select t1.last_name,t1.first_name,t2.dept_name from employees t1 left join ( select c.em...

2023-03-19

0 320

题解 | #获取当前薪水第二多的员工号及其对应的薪水#

#套娃 select emp_no,salary from salaries where salary=( select max(a.salary) from salaries a where a.emp_no<> ( selec...

2023-03-19

0 199

题解 | #获取所有非manager员工当前的薪水情况#

#非manager员工编号emp_no,部门dept_no /* select b.emp_no,c.dept_no from dept_emp b join dept_manager c on b.dept_no=c.dept_no where b.emp_no ...

2023-03-17

0 310

题解 | #统计出当前各个title类型平均工资#

select a.title,avg(b.salary) from titles a join salaries b on a.emp_no=b.emp_no group by a.title;

2023-03-17

0 349

题解 | #查找表emp_no与last_name信息#

select * from employees where emp_no%2=1 and last_name<>'Mary'order by hire_date desc ; #不等于可以用 where 加<>进行条件限制 #奇偶条件where a%2=0

2023-03-17

0 278

题解 | #对所有员工薪水按salary降序排名#

select a.emp_no,a.salary,b.t_rank from salaries a join ( select salary,dense_rank() over(order by salary desc) t_rank from...

2023-03-17

0 307

题解 | #获取每个部门中当前员工薪水最高的相关信息#

#每个部门最高的薪资怎么求,以下表设为t1 /* select a.dept_no,max(b.salary) salary from salaries b join dept_emp a on b.emp_no = a.emp_no group by a....

2023-03-16

0 291