1.
select distinct name,
first_value(month) over(partition by name order by money) min_month,
first_value(month) over(partition by name order by money desc) max_month,
(max(money) over(partition by name) - min(money) over(partition by name)) money
from table12.
select distinct month,
first_value(name) over(partition by month order by money) min_name,
first_value(name) over(partition by month order by money desc) max_name,
(max(money) over(partition by month) - min(money) over(partition by month)) money
from table1
select distinct name,
first_value(month) over(partition by name order by money) min_month,
first_value(month) over(partition by name order by money desc) max_month,
(max(money) over(partition by name) - min(money) over(partition by name)) money
from table12.
select distinct month,
first_value(name) over(partition by month order by money) min_name,
first_value(name) over(partition by month order by money desc) max_name,
(max(money) over(partition by month) - min(money) over(partition by month)) money
from table1
解决方案 »
- 求解决:Oracle 安装 , general_purpose.dbc不存在!
- 两个大表的关联查询问题-如何提高效率
- ?????帮助偶解决存储过程速度慢的问题的200分都给您老,没有第二!
- 如此select语句 你会写吗?
- 哪一条语句的执行效率高?
- 怎么样在ORACL数据库中能象SYBASE一样的在前台调用存储过程执行SQL
- 关于查询ORACLE数据库返回记录的总值?
- 如何在Java中存取oracle8i的CLOB字段?(在线等待)
- 紧急求救:oracle8.1.7服务端启动时出现的奇怪现象
- oracle同时删除多条记录
- 棘手的一个问题,有关 update上锁的问题,update 语句对表中记录修改时上exclusive锁!
- 查询学习名次在30-50位,的select怎么写?
张三 1,2002,1,100.33
张三 1,2002,2, 200。22
张三 1,2002,3, 300。22
...
李四 1,2002,1,300。66
李四 1,2002,2,300。66
李四 1,2002,3,412。66
选出某个车间,每年,每个月金额相差最大的两个人,并显示金额
---有可能是空值(比如张三5月没有记录)....
chejian1,1995,1,张三,李四,100。11
chejian1,1995,2,王武,赵六,30。11
chejian1,1995,2,王武,李四,30。11
2.
select distinct chejian,year,month,
first_value(name) over(partition by chejian,year,month order by money) min_name,
first_value(name) over(partition by chejian,year,month order by money desc) max_name,
(max(money) over(partition by chejian,year,month) - min(money) over(partition by chejian,year,month)) money
from table1