Hello,

I want result of following query in one row. This Formno 13534 has 3 risks, which I want to denorlmalize into one record.

So result will show like this...

formno risk1 risk2 risk3, desp
13534 1 2 3 SSR

I tried following way. which gives 3 records. Table has Formno,risk,desp fields. Please correct me in this.

select formno,decode(rownum,1,risk) risk1,decode(rownum,2,risk) risk2,decode(rownum,3,risk) risk3,desp from Formrisks where Desp='SSR'and Fromno=13534 and rownum<=3;


Thanks & Regards
Shailesh