-
Hi,
If i have the following sql and it will returns more than 1 record.
select subjects from students
where name = 'oracle';
result:
science
maths
english
in this case, how do i concat it so that it will returns me science||maths||english in a single row? Any help pls? Thanks! :D
-
Use subQuery technique to get your desired result.
-
Thanks for the reply. Any examples please?
Thanks in advance!
-
Hi.
u wanted to transpose the rows right...there are people who did it using MULTIPLe decodes !! just search in the forum for TRANSPOSE..
