SELECT EmployeeID
FROM Employee
WHERE EmployeeID NOT IN
(SELECT DISTINCT isnull(ManagerID,'')
FROM Employee
)
FROM Employee
WHERE EmployeeID NOT IN
(SELECT DISTINCT isnull(ManagerID,'')
FROM Employee
)
解决方案 »
- SQL 关联语句错误
- 鬱悶,被這個油標弄瘋啦
- sql server 一个字段拆分成多个字段显示
- 再安装sql server的时候哪里可以设置表里面数据去分大小写啊!谢谢
- 请问触发器是怎么样工作的?比如我批量更新的时候,它内部是如何操作的?是单条触发还是同时多条触发?
- SQL 行汇总方法??
- 我用的是英文版SQL2000做中文网页会不会有问题。
- 如何打开Sql Server生成的db文件?
- asp中向sql server 上传照片如何处理!!!
- 紧急求助!!!公司要选择数据库。到底是用vb.+sql server 还是 vb+oracle??
- varchar类型最大能存8000个字符,为什么我设其Length为8000却只能输入大概1000个字符呢?
- 新手问题
FROM Employee a
WHERE not exists (SELECT 1 FROM Employee
where ManagerID=a.EmployeeID
)
FROM Employee
WHERE EmployeeID IN
(SELECT ManagerID
FROM Employee
group by ManagerID
having count(*) =0
)
FROM Employee a left join
(select SELECT DISTINCT ManagerID
FROM Employee where ManagerID is not null) b on a.EmployeeID=b.ManagerID
WHERE b.ManagerID is null
having count(*) = 0 是不可能有结果的
FROM Employee a left join
(select SELECT DISTINCT ManagerID
FROM Employee where ManagerID) b on a.EmployeeID=b.ManagerID
WHERE b.ManagerID is null
FROM Employee
WHERE EmployeeID not IN
(SELECT ManagerID
FROM Employee
where ManagerID is not null
group by ManagerID
)