解决我的问题我是Sql的初学者 [英] Solve My Problem I Am Beginner In Sql

问题描述

我有三张桌子

员工（TB1）员工姓名（TB2）经理（TB3）部门（TB4）

ID Ecode Dept ID Ename Mcode ID deptName

1 10 1 1 raja NULL 1管理员

2 20 2 2 siva 10 2 prodn

3 30 3 3 kamal 60 3账户

4 40 5 4 ramu 100





1）作为管理人员的员工名单

2）非管理人员员工名单

3）员工总数在每个部门都有部门名称

4）各部门经理总数，部门名称

5）名字未定义的员工

6）部门ID无效的员工

I have three tables
Employee (TB1) Employee Name(TB2) Manager(TB3) Department(TB4)
ID Ecode Dept ID Ename Mcode ID deptName
1 10 1 1 raja NULL 1 Admin
2 20 2 2 siva 10 2 prodn
3 30 3 3 kamal 60 3 Accounts
4 40 5 4 ramu 100


1) List of employees who are managers
2) List of employees who are not managers
3) Total number of employees in each department with department name
4) Total number of manager in each department with department name
5) Employee whose name is not defined
6) Employee whose department id is not valid

推荐答案

如果我们做完作业，我们不会帮助你，你应该自己动手，因为它并不困难。请参考此处： SQL教程 [ ^ ]

CP可以帮助人们学习。我们既不做他们的作业/家庭作业/项目也不提供源代码。

你尝试了什么 [ ^ ]

如果您的编码遇到任何困难，始终先咨询Google，其他一切都失败，然后访问CP并提出与特定问题相关的问题。

We are not helping you if we do your homework, you should do it yourself as it is not that difficult. Take reference from here: SQL tutorial[^]
CP helps people to learn. We neither do their assignments/homeworks/projects nor supply source code.
what-have-you-tried[^]
If you encounter any difficulties with your coding, always consult Google first, everything else fails, then visit CP and ask questions related to specific issues.

这篇关于解决我的问题我是Sql的初学者的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！