列出emp表下没有下级的员工

520tjm

Yong Huang 发表于 2013-3-29 00:44
What is PT? What is HDC?

PT（Private Tracker）,actually is the kind of bt download.HDC(High Definition China）is a website can be called PT station.In there,you can download many High Definition video(films, Variety show, soap opera and so on...)

520tjm

like this，you can watch what you like。。。

小小菜皮

如果是oracle自带的sample那个employees的话，可以
select e1.employee_id,e1.first_name from employees e1
where not exists
(select * from employees e2
where e1.employee_id=e2.manager_id)
order by 1
/

如果要查看层级的话：

select level,e1.employee_id,e1.first_name, e1.manager_id from employees e1
where not exists
(select * from employees e2
where e1.employee_id=e2.manager_id)
start with e1.employee_id=100
connect by prior e1.employee_id=e1.manager_id
order by 1,2
/