高级资深攻城狮

分类

题解(90)

/ 注册

全部文章（共16篇）

题解 | #找到每个人的任务#

总之解决了问题，代码有点长：select date,( select count() from ( select date,type from email e where e.send_id in ( sele...

Sqlite

2021-09-29

0 263

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

select first_name from employees order by substring(first_name,-2) select first_name from employees order by substr(first_name,-2 ) select first_name ...

Sqlite

2021-09-28

0 220

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

Mysql: select concat(employees.last_name,"'",employees.first_name) from employeesSqllite: select employees.last_name||"'"||e...

Sqlite

2021-09-27

0 310

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

update salaries set salaries.salary = salaries.salary*(1.1)where salaries.to_date='9999-01-01' and salaries.emp_no in(select emp_no from emp_bonus)使用...

Sqlite

2021-09-27

0 172

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

alter table audit add constraint foreign key (emp_no) references employees_test(id)添加外键方法，alter table “table_name” add constraint foreign key(“table_n...

Sqlite

2021-09-27

0 225

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

update titles_test set emp_no=replace(emp_no,10001,10005) where id=5 and emp_no=10001replace(column_name,x,y)函数用法，将column_name由想，替换成y使用update结合replace...

Sqlite

2021-09-27

0 260

题解 | #将所有to_date为9999-01-01的全部更新为NULL#

update titles_test set to_date=null,from_date='2001-01-01'where to_date='9999-01-01'update table_name set column_name="value" where column=&...

Sqlite

2021-09-27

0 239

题解 | #对所有员工的薪水按照salary降序进行1-N的排名#

select dept_emp.dept_no as dept_no,departments.dept_name as dept_name,titles.title as title ,count(s1.emp_no) from (dept_emp left join departments ...

Sqlite

2021-09-24

0 215

题解 | #对所有员工的薪水按照salary降序进行1-N的排名#

select c.name,count(f_c.film_id) as cffrom category c inner join film_category f_c on c.category_id=f_c.category_id inner join film f on f_c.film_id=f...

Sqlite

2021-09-24

0 241

题解 | #对所有员工的薪水按照salary降序进行1-N的排名#

运行通过，解题思路：先从dept_manager，salaries中查出经理的工号，部门号，薪资，然后再从salaries和dept_emp中查出部门号相等，工号不等，薪资大于经理的员工工号，薪资和部门号。select salaries.emp_no,manager_info.emp_no,sa...

Sqlite

2021-09-23

0 243