Posts Tagged ‘分析函数’
今天一同事问我怎么用一条sql语句实现如下功能：
ID AMOUNT
—————–
1 3
2 5
3 6
4 8
要得到这样的结果：
ID AMOUNT TOTAL
———————–
1 3 3
2 5 8
3 6 14
4 8 22
这个问题是很常见也是很简单的问题，有两种解决方法：
Page 1 of 11
搜索本站
站点日历
| 一 | 二 | 三 | 四 | 五 | 六 | 日 |
|---|---|---|---|---|---|---|
| « 4 | ||||||
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 | |
订阅本站
文章分类
- upgrade
- 一些事
- 2010第一贴
- 用BBED修复坏块
- 93分
- 没有眼镜真不方便
- 还是换了
- 如何看到本站的图片
- 有图有真相
- 坚持跑步
- try 1 try
- ANS1312E (RC12) Server media mount not possible
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections
- 项目介绍：一客户MES系统升级
- ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
最新日志
- expdp常见用法 (6,335)
- IMP-00010: 不是有效的导出文件，标题验证失败 (5,056)
- ORA-12500: TNS: 监听程序无法启动专用服务器进程 (3,904)
- ORA-01102: cannot mount database in EXCLUSIVE mode (3,503)
- 一则ora-03113错误的解决 (3,427)
- Checking monitor:must be configured to display at least 256 colors (3,285)
- ORA-12545:Connect failed because target host or object does not exist (3,202)
- CRS无法启动的解决过程 (2,657)
- ORA-02019: connection description for remote database not found (2,469)
- ORA-12535: TNS: 操作超时 (2,237)
- 【ZT】Oracle分布式事务故障处理 (2,132)
- ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (2,094)
- ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (2,082)
- Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (1,899)
- 苏州圆融时代广场 (1,872)
- WARNING: inbound connection timed out (ORA-3136) (1,865)
- Oracle CRS log (1,862)
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections (1,798)
- Oracle RAC升级问题记录 (1,628)
- 主键约束引起ORA-02429错误 (1,546)