select lpad(fam,length(fam)+level*2-2,'.') hierarchy1 from spis_sot start with fam='Соболев' connect by prior kod_sotr=parent_id;
раскрыть ветку (1)
8. select F.fam,F.oklad,S.fam,S.oklad, F.avg_zp,F.kod_otdel from
(select F.*,
round(avg(oklad) over (partition by kod_otdel),2) as avg_zp
from spis_sot F) F
left join spis_sot S
on F.kod_otdel=S.kod_otdel
where F.oklad<S.oklad
and F.oklad>F.avg_zp
7. select lpad(fam,length(fam)+level*2-2,'.') hierarchy1 from spis_sot start with fam='Соболев' connect by prior kod_sotr=parent_id order by level, fam;
select lpad(fam,length(fam)+level*2-2,'.') hierarchy1 from spis_sot start with fam='Соболев' connect by prior kod_sotr=parent_id;
показать ответы
