高级资深攻城狮
高级资深攻城狮
全部文章
分类
题解(90)
归档
标签
去牛客网
登录
/
注册
高级资深攻城狮的博客
全部文章
(共51篇)
题解 | #批量插入数据#
insert ignore into actor(actor_id,first_name,last_name,last_update) values(1,'PENELOPE','GUINESS','2006-02-15 12:34:33'),(2,'NICK','WAHLBERG','2006-02...
Mysql
2021-09-26
0
185
题解 | #创建一个actor表,包含如下列信息#
insert into actor values(1,'PENELOPE','GUINESS',"2006-02-15 12:34:33");insert into actor values(2,'NICK','WAHLBERG',"2006-02-15 12:34:3...
Mysql
2021-09-26
0
163
题解 | #创建一个actor表,包含如下列信息#
drop table if exists actor ;CREATE TABLE actor ( actor_id smallint(5) NOT NULL, first_name varchar(45) NOT NULL, last_name varchar(45) NOT NULL, ...
Mysql
2021-09-26
0
166
题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#
select title,description from film f,film_category f_cwhere f.film_id=f_c.film_id and category_id in(select category_id from category where name ='act...
Mysql
2021-09-26
0
175
题解 | #使用join查询方式找出没有分类的电影id以及名称#
select f.film_id,f.titlefrom film f left join film_category f_c on f.film_id=f_c.film_id left join category c on f_c.category_id=c.category_idwhere f....
Mysql
2021-09-26
0
245
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
运行结果正确,可以稳定运行select dept_no,dept_name,count(dept_no)from ( select emp_no,dept_emp.dept_no,departments.dept_name from dept_emp left join ...
Mysql
2021-09-22
0
183
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
select hire_salary.emp_no,current_salary-hire_salary as growth from ( select salaries.salary as hire_salary,salaries.emp_no as emp_no from s...
Mysql
2021-09-22
0
178
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
select last_name,first_name,dept_name from employees e LEFT JOIN dept_emp d on e.emp_no=d.emp_no LEFT join departments dp on d.dept_no=dp.dept_no三个表进...
Mysql
2021-09-18
0
224
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
通过测试,代码如下select salaries.emp_no,salaries.salary,employees.last_name,employees.first_name from salaries,employees where salary in (select max(salary...
Mysql
2021-09-17
0
283
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
select emp_no,salary from (select emp_no,salary from salaries order by salary DESC limit 2) as a ORDER by salary LIMIT 1这道题的关键是起别名,我的解题思路为:先查出结果降序排...
Mysql
2021-09-16
0
160
首页
上一页
1
2
3
4
5
6
下一页
末页