(1):需求
select * from zhanggh_pd_serial2
assetid assettype name propertycode fileid pathname
1 1660643 1101 叮当猫 Poster 24125922 d09082700360003000.JPG
2 1660643 1101 叮当猫 BigPhoto 24125918 d09082700360001000.JPG
3 1660643 1101 叮当猫 OplusPhoto 24125920 d09082700360002000.JPG
4 1660643 1101 叮当猫 SmallPhoto 24125924 d09082700360004000.JPG
现在要以 assetid assettype name 列显示
(2):解决 使用oracle的 max(decode )来解决----
select t2.assetid 资产ID ,t2.assettype 资产类型,t2.name 片名,
max(decode (t2.propertycode,'Poster',t2.propertycode,null)) Poster ,max(decode(t2.propertycode,'Poster',t2.pathname,null)) 大海报,
max(decode (t2.propertycode,'BigPhoto',t2.propertycode,null)) BigPhoto ,max(decode(t2.propertycode,'BigPhoto',t2.pathname,null))大图片,
max(decode (t2.propertycode,'SmallPoster',t2.propertycode,null)) SmallPoster ,max(decode(t2.propertycode,'SmallPoster',t2.pathname,null)) 小海报,
max(decode (t2.propertycode,'SmallPhoto',t2.propertycode,null)) SmallPhoto ,max(decode(t2.propertycode,'SmallPhoto',t2.pathname,null)) 小图片
from zhanggh_pd_serial2 t2
group by t2.assetid,t2.assettype,t2.name
--------------------------------------------------------------------------
assetid assettype name Poster 大海报 BigPhoto 大图片 SmallPoster 小海报 SmallPhoto 小图片
1660643 1101 叮当猫 Poster d09082700360003000.JPG BigPhoto d09082700360001000.JPG SmallPhoto d09082700360004000.JPG
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15713890/viewspace-669687/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15713890/viewspace-669687/