球球了美好快出现吧别再铺垫了

分类

题解(6)

/ 注册

全部文章（共4篇）

join大法

select title,description from ( select ff.title,ff.description,c.name from film_category fc join film ff on fc.film_id=ff.film_id ...

sql

2020-08-05

1 528

左连接，取category_id为null的记录

select f1.film_id,f1.title from film f1 left join( select fc.film_id,fc.category_id from film_category as fc join category as c on fc....

2020-08-05

0 564

l两个salary子查询相减

select s1.emp_no,s2.from_date, (s2.salary-s1.salary)as salary_growthfrom( select s.emp_no,s.salary,s.from_date,strftime('%Y', from_date) as ...

2020-08-05

0 645

子查询

select d.dept_no,d.dept_name,a.title, a.count_title as countfrom departments djoin( select dept_no,title,count(t.title) as count_title fr...

sql

2020-08-05

1 711