海纳冰川，人纳天下，龙纳万物

题解

/ 注册

全部文章 / 题解（共5篇）

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

SELECT * from order_infowhere status='completed' and product_name in('java','C++','PYTHON')and date>'2025-10-15' and user_id in(SELECT user_id fr...

2021-07-20

0 388

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

SELECT user_id from order_infowhere status='completed' and product_name in('java','C++','PYTHON')and date>'2025-10-15'GROUP by user_idHAVING COUNT...

2021-07-20

0 280

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

select emp_no,salary from salariesorder by salary desc limit 1 offset 1 select emp_no,salary from salariesorder by salary desc limit 1,1

2021-06-20

0 386

题解 | #查找当前薪水详情以及部门编号dept_no#

一个多表连接案例select dept_manager.emp_no,salary,from_date,dept_manager.to_date,dept_no from salaries, dept_manager where salaries.emp_no=dept_manager....

2021-06-19

2 364

题解 | #查找最晚入职员工的所有信息#

select * from employees where hire_date like (select hire_date from employees &nbs...

2021-06-19

2 275