select mainline+'/'+subline from table1 where mainline='54326'Here I m getting output like thiso/p:Mainline 54326/154326/2the above query i m getting output in two linebut i need an single line output like i mentioned below Mainline54326/1, 54326/2anybody please post solution for this.....