创建一个简单的员工信息表
Create Table EmployeeInfo (CO
Constraint PK_EmployeeInfo Primary Key (CO
--CO
Select * From EMPLOYEEINFO
SQL语句:
Select DEPARTMENTID,
Min(SALARY) Keep (DENSE_RANK First Order By SALARY Desc) "FIRST",
Max(SALARY) Keep (DENSE_RANK Last Order By SALARY Desc) "LAST"
From EMPLOYEEINFO Group By DEPARTMENTID
--此语句的返回结果是每个部门最高的工资和最低的工资:
SQL语句:
Select EmployeeName,DEPARTMENTID,SALARY,
Min(SALARY) Keep (DENSE_RANK First Order By SALARY Desc) OVER (Partition By DEPARTMENTID) "FIRST",
Max(SALARY) Keep (DENSE_RANK Last Order By SALARY Desc) OVER (Partition By DEPARTMENTID) "LAST"
From EMPLOYEEINFO Group By DEPARTMENTID,SALARY,EmployeeName
--此语句返回结果比上述查询更详细,增加了员工姓名: