海纳冰川,人纳天下,龙纳万物
海纳冰川,人纳天下,龙纳万物
全部文章
分类
题解(9)
归档
标签
去牛客网
登录
/
注册
海纳冰川,人纳天下,龙纳万物的博客
全部文章
(共7篇)
题解 | #高级操作符练习(2)#
select device_id,gender,age,university,gpa from user_profile where university='北京大学' or gpa>3.7
2022-11-07
0
86
题解 | #高级操作符练习(1)#
select device_id,gender,age,university,gpa from user_profile where gender='male' and gpa>3.5
2022-11-07
0
133
题解 | #牛客的课程订单分析(二)#
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
377
题解 | #牛客的课程订单分析(二)#
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
274
题解 | #获取当前薪水第二多的员工的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
380
题解 | #查找当前薪水详情以及部门编号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
355
题解 | #查找最晚入职员工的所有信息#
select * from employees where hire_date like (select hire_date from employees &nbs...
2021-06-19
2
262