Oracle中聚合开窗函数

最新推荐文章于 2023-08-20 21:53:43 发布

greeneea

最新推荐文章于 2023-08-20 21:53:43 发布

阅读量91

点赞数

分类专栏： sql 文章标签：数据库 sql

本文链接：https://blog.csdn.net/greeneea/article/details/129212712

版权

求每个部门中工资大于部门平均工资的人员信息

CREATE TABLE T_Person (
FName VARCHAR2(20), --Oracle中的类型，MySQL中运行报错
FCity VARCHAR2(20),
FAge INT,
FSalary INT)

INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('Tom','BeiJing',20,3000);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('Tim','ChengDu',21,4000);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('Jim','BeiJing',22,3500);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('Lily','London',21,2000);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('John','NewYork',22,1000);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('YaoMing','BeiJing',20,3000);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('Swing','London',22,2000);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES('Guo','NewYork',20,2800);
INSERT INTO T_Person(FName,FCity,FAge,FSalary)
VALUES