改为
select t.receiver_name receiver_name, t.transaction_group_name transaction_group_name,count(*) summary
from receive_rep_v t ,receive_rep_v t1
where t.receiver_name = t1.receiver_name
group by t.receiver_name,t.transaction_group_name
order by t.transaction_group_name
select t.receiver_name receiver_name, t.transaction_group_name transaction_group_name,count(*) summary
from receive_rep_v t ,receive_rep_v t1
where t.receiver_name = t1.receiver_name
group by t.receiver_name,t.transaction_group_name
order by t.transaction_group_name
解决方案 »
- 如何列出或较验指定备份集或映像副本的状态?
- 怎么看Scott.dept这个表的结构?
- oracle10g net configuration assistant :net 服务名的配置
- oracle连接SQL 2000的问题
- 用utl_tcp发送信息的问题?
- 请假一个sal语句,本人愚笨,试了一天也没整出来
- 并行服务器
- 我想考Oracle8i的OCP,能不能列个机械出版社的图书目录?
- oracle enterprise manager console登陆问题???
- 服务ManagerServer无法写入注册表
- 请问用ADO连接ORACLE能否不装客户端?
- 在广州有没有oracle9i的光盘卖?
from receive_rep_v
group by receiver_name,transaction_group_name
order by transaction_group_name