现在业务需要建个视图
但建立的视图,每一条数据都没有一个字段可以用来作为唯一标示来区别这条数据。
请问如何解决?
可以增加个序列吗?如果可以,怎么写?附上视图脚本:CREATE OR REPLACE VIEW v_Load_Dis_Charge_info
(
nums,
vessel_m,
voyage_n,
size_q,
operator_c,
status_c,
type_c,
inland_trade_i,
shipping_status_c
)
AS
select
count(*) as nums,
loading_vessel_m,
LOADING_VOYAGE_N,
size_q,
out_slot_operator_c,
status_c,
type_c,
inland_trade_i,
'出口' as shipping_status_c
from cntr
where shipping_status_c in ('EX','RE','RS') group by out_slot_operator_c,size_q,status_c,type_c,inland_trade_i,loading_vessel_m,LOADING_VOYAGE_N
union select
count(*) as nums,
discharge_vessel_m,
discharge_VOYAGE_N,
size_q,
in_slot_operator_c,
status_c,
type_c,
inland_trade_i,
'进口' as shipping_status_c
from cntr
where shipping_status_c in ('IM','OL')
group by in_slot_operator_c,size_q,status_c,type_c,inland_trade_i,discharge_vessel_m,discharge_VOYAGE_N
但建立的视图,每一条数据都没有一个字段可以用来作为唯一标示来区别这条数据。
请问如何解决?
可以增加个序列吗?如果可以,怎么写?附上视图脚本:CREATE OR REPLACE VIEW v_Load_Dis_Charge_info
(
nums,
vessel_m,
voyage_n,
size_q,
operator_c,
status_c,
type_c,
inland_trade_i,
shipping_status_c
)
AS
select
count(*) as nums,
loading_vessel_m,
LOADING_VOYAGE_N,
size_q,
out_slot_operator_c,
status_c,
type_c,
inland_trade_i,
'出口' as shipping_status_c
from cntr
where shipping_status_c in ('EX','RE','RS') group by out_slot_operator_c,size_q,status_c,type_c,inland_trade_i,loading_vessel_m,LOADING_VOYAGE_N
union select
count(*) as nums,
discharge_vessel_m,
discharge_VOYAGE_N,
size_q,
in_slot_operator_c,
status_c,
type_c,
inland_trade_i,
'进口' as shipping_status_c
from cntr
where shipping_status_c in ('IM','OL')
group by in_slot_operator_c,size_q,status_c,type_c,inland_trade_i,discharge_vessel_m,discharge_VOYAGE_N
解决方案 »
- oracle11gR2安装问题
- 数据库 删除 之后重新建立的 问题
- 怎样写group by处理交叉组合的统计?
- Oracle中的ST_FUNCS_ARRAY什么类型 和sql中的什么类型对应啊???
- apex3.2 创建后执行apex_epg_config失败, apex无法登录管理界面
- 小弟来问个问题,关于连接查询,存在重复记录时,只连接显示唯一一条。。
- concat或||遇到小数点就有问题,怎么解决?
- 关于Oracle中的特殊字符“&”(&)
- 请问有没有oracle for solaris(intel)的下载???
- oracle jdbc 连接池 B/S动态实时程序在多客户端同时登录时存在延迟卡顿的问题
- 新手问题,关于服务器搬迁
- oracle安装后,plsql访问的时候提示‘ORA-12154:TNS:无法解析指定的连接标志符’
加了这个,groupby里也要加rownum,这样就起不到作用了。
select
nums,
loading_vessel_m,
LOADING_VOYAGE_N,
size_q,
out_slot_operator_c,
status_c,
type_c,
inland_trade_i,
shipping_status_c,
rownum as id
from (
select
count(*) as nums,
loading_vessel_m,
LOADING_VOYAGE_N,
size_q,
out_slot_operator_c,
status_c,
type_c,
inland_trade_i,
'出口' as shipping_status_c
from cntr
where shipping_status_c in ('EX','RE','RS') group by out_slot_operator_c,size_q,status_c,type_c,inland_trade_i,loading_vessel_m,LOADING_VOYAGE_N
union select
count(*) as nums,
discharge_vessel_m,
discharge_VOYAGE_N,
size_q,
in_slot_operator_c,
status_c,
type_c,
inland_trade_i,
'进口' as shipping_status_c
from cntr
where shipping_status_c in ('IM','OL')
group by in_slot_operator_c,size_q,status_c,type_c,inland_trade_i,discharge_vessel_m,discharge_VOYAGE_N
)