ocp学习随记（三）

今天主要执行的命令如下:

select 
e.last_name last_name ,e.salary salary ,e.DEPARTMENT_ID,e1.salavg
from employees e,(select DEPARTMENT_ID,avg(salary) salavg from employees group by DEPARTMENT_ID) e1
where e.DEPARTMENT_ID=e1.DEPARTMENT_ID
and e.salary>e1.salavg
/
select 
e1.last_name||' '||e1.first_name name,
e2.last_name||' '||e2.first_name name2 from employees e1,
(select manager_id from employees group by manager_id) e2
where e1.manager_id in e2.manager_id
/
select t1.id t1 ,t3.id t3
from test1 t1,
(select count(*)/2 tt from test1) t2,
test1 t3
where t1.id<=t2.tt
and t3.id>t2.tt
/
select a.id t1 ,b.id t2
from test1 a,test1 b,
(select count(*)/2 tt from test1) c
where a.id=b.id(+)-c.tt
and a.id<=c.tt
/

主要学习了连接 的部分知识,以及pl/sql的基础入门,另外还有decode()函数的使用

decode函数可以用来实现行换列,通过sum嵌套,如sum(decode(字段,value1,0)),可以把行内容转为列显示