liuyanjun

13207145280
2428 号测试 成员, 2020-03-25 03:22:51 加入
702
个人主页浏览
  • 20200324 连接查询作业

    2020-07-24 10:57

    第一题:select * from emp as a inner join dept as
    b on a.dept_id=b.id where a.name like '张%';
    image.png

    第二题:select * from emp as a where dept_id=1 and leader=1;
    image.png

    不知道怎么计数

    第三题:select * from emp as a where dept_id=1 and leader=1
    image.png