Hello,
Using : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
Windows XP Service Pack 1
Please help me to write a select query as below:
create table student(eno varchar2(10),rno varchar2(5),r0 number(5),r1 number(5),r2 number(5),r3 number(5));
insert into student values ('9352','A0000',0,0,0,0);
insert into student values ('15401','A0006',0,0,0,0);
insert into student values ('9478','A0000',0,0,0,0);
insert into student values ('6712','A0000',0,0,0,0);
insert into student values ('12410','A0006',0,0,0,0);
insert into student values ('9477','A0001',0,0,0,0);
commit;
Required output:
ENO RNO R0 R1 R2 R3
---------- ----- ---------- ---------- ---------- ----------
9352 A0000 6712 9478 0 0<--column output Should be asc order for column R0 to R3
15401 A0006 12410 0 0 0
9478 A0000 6712 9352 0 0
6712 A0000 9352 9478 0 0
12410 A0006 15401 0 0 0
9477 A0001 0 0 0 0
There will not more than 5 rows for a RNO. I am not getting any clue to get the output; so till now i have'nt write anything to get output.
Please guide me.
Thanks & Regards
Girish Sharma