如果我们按照示例想得到每个部门薪水值最高的雇员的纪录,可以有四种方法实现:
先创建示例表
create
table
emp
as
select * from scott.emp;
alter table emp
add constraint emp_pk
primary key (empno);
create
as
select * from scott.emp;
alter table emp
add constraint emp_pk
primary key (empno);
create