SQL qry doubt ... [message #187708] |
Tue, 15 August 2006 01:50 |
frank.svs
Messages: 162 Registered: February 2006
|
Senior Member |
|
|
Hi pals,
Can anyone pls hel me out. I want qry such that it dislays rows as columns in the output.Something like crosstab reports.
Can we do that.
Example my table name is sample.
create table samle(id number,name varchar2(20),sal number);
insert into sample values(1,'zach',9000);
insert into sample values(2,'raj',4000);
insert into sample values(3,'sam',5000);
commit;
now i want to display my outut as follows:
1 2 3
zach raj sam
9000 4000 5000
pls help me out.
Thanks in Advance.
Franky
|
|
|
|