注册会员
157
0
14
收藏0回复 只看该作者 道具 举报
点评 回复 只看该作者 道具 举报
新手上路
SQL> select id, 2 (select count(distinct name) from test t2 where t2.id <= t1.id) as accundv 3 from test t1 4 group by id 5 / ID ACCUNDV --------------------------------------- ---------- 1 2 2 3 4 4 3 3 SQL>
回复 只看该作者 道具 举报
发表回复 回帖后跳转到最后一页
|手机版|Archiver|Oracle数据库数据恢复、性能优化
GMT+8, 2024-12-26 02:20 , Processed in 0.053464 second(s), 21 queries .
Powered by Discuz! X2.5
© 2001-2012 Comsenz Inc.