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 | ||||
订阅本站
文章分类
- 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
最新日志
- ORA-02019: connection description for remote database not found (11,328)
- expdp常见用法 (10,885)
- ORA-01102: cannot mount database in EXCLUSIVE mode (10,372)
- IMP-00010: 不是有效的导出文件，标题验证失败 (8,970)
- 一则ora-03113错误的解决 (8,113)
- CRS无法启动的解决过程 (7,553)
- ORA-12500: TNS: 监听程序无法启动专用服务器进程 (6,668)
- ORA-12545:Connect failed because target host or object does not exist (6,661)
- Checking monitor:must be configured to display at least 256 colors (6,432)
- ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (4,442)
- ORA-12535: TNS: 操作超时 (4,417)
- ORA-12528: TNS:listener: all appropriate instances are blocking new connections (4,382)
- 【ZT】Oracle分布式事务故障处理 (4,345)
- Oracle CRS log (4,312)
- ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (4,308)
- 苏州圆融时代广场 (3,867)
- Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (3,691)
- WARNING: inbound connection timed out (ORA-3136) (3,638)
- 2010第一贴 (3,295)
- ANS1312E (RC12) Server media mount not possible (3,264)