怎么把上面的结果查询成 下面这种形式:shop_id image_url status image_url status
77901051 H:\File\11111.jpg 0 H:\File\2222.jpg 1非常感谢 !!!
解决方案 »
- 求教RAC splite brain脑裂决议问题
- 2个各有2,3条记录的表做关联,怎么查出来19条记录?
- 9I数据库迁移到10G后同样的查询语句为什么执行时间变慢了很多。
- 我想通过fckeditor保存从Word文档复制出来的文本,存入oracle9i数据库,字段类型用什么呢?blob?clob?
- 这样做的好处是什么?
- 急待:ORACLE数据库中的某个表数据导到磁带机上.
- 我的Oracle9怎么用不了呢?
- 求救:Oracle触发器的简单问题,高分奉送,在线等待!
- 在ORACLE版本切换时碰到一个奇怪的问题,一条原本正确的SQL语句出现错误
- ORACLE SQL 数据合并
- goldengate windows安装、配置,单向复制的教程详细一点大家有吗?
- 自动追踪转账规律(oracle语句)
with t1 as
(select a*,row_number()over(partition by shop_id order by sysdate) as rn from table1)
select t1.shop_id,t1.image_url,0 as "status", tab1.image_url, 1 as "status1" from t1 where rn=1
join (select * from t1 where rn=2) tab1 on t1.shop_id =tab1.shop_id
(select t.*, row_number() over(partition by t.shopid order by t.status) rn
from t_shop t)
select v.shopid,
max(decode(v.rn, 1, v.image_url)) image_url_1,
'0' status_1,
max(decode(v.rn, 2, v.image_url)) image_url_2,
'1' status_2
from v
group by v.shopid;-- 11g 特有pivot函数
with v as
(select shopid,
image_url,
row_number() over(partition by t.shopid order by t.status) rn
from t_shop t)
select v1.shopid,
v1."1_IMAGE_URL",
'0' status_1,
v1."2_IMAGE_URL",
'1' status_2
from (select * from v pivot(max(v.image_url) as image_url for rn in(1, 2))) v1;