Hina Softwares, Kattumannarkoil

Oracle Reports - Row/Columnwise Table Result




select signature,a,
S_EXAM_DATE,
s_sess_id,
paper_name,code,s_branch,s_semester,
count(b) ct,
max(decode(b,1,regno)) row1,
max(decode(b,2,regno)) row2,
max(decode(b,3,regno)) row3,
max(decode(b,4,regno)) row4,
max(decode(b,5,regno)) row5,
max(decode(b,6,regno)) row6,
max(decode(b,7,regno)) row7
from
(select * from f_x  ORDER BY REGNO)
group by signature,a ,s_exam_date,s_sess_id,paper_name,
code,s_branch,s_semester
order by a


Responses

0 Respones to "Oracle Reports - Row/Columnwise Table Result"

Post a Comment

Comment

 

Recent Comments

Popular Posts

Return to top of page Copyright © 2010 | Hina Softwares