DragonZhu
DragonZhu
全部文章
分类
题解(3)
归档
标签
去牛客网
登录
/
注册
DragonZhu的博客
全部文章
(共3篇)
虽然麻烦但是挺好理解
select g.id as id,g.name as name,g.weight as weight,tt.total as total from goods as g left join trans as t on g.id = t.goods_id left join ( select t...
Mysql
2022-05-05
0
191
题解 | #使用子查询的方式找出属于Action分类的所有电影对应的title,description#
子查询,下面的SQL逻辑很清晰。 #最后用film_id查电影表中的title与description select title,description from film where film_id IN ( #再用查到的categoryid查询对应关系表中的film_id se...
2021-07-11
1
413
题解 | #使用join查询方式找出没有分类的电影id以及名称#
select f.film_id,f.title from film as f left join film_category as fc on f.film_id = fc.film_id left join category as c on c.category_id = fc.catego...
2021-07-10
0
313