Re: display rows beside each-other

Try this:

select max(case when rownum = 1 then name else null end) || ' ' || max(case when rownum = 2 then name else null end)

from mytable

where rownum < 3;

"Ronald" <rmoleveld_at_hotmail.com> wrote in message news:1113564442.971966.215760_at_g14g2000cwa.googlegroups.com...
> hi, thanks.
>
> It's only for a max of 2 or 3 records (about 30 char long total.)
>
> But so far I see this only works on plsql isn't it ?
>
> Is there also a sql (beside plsql) solution ?
>
> Ronald.
>
Received on Fri Apr 15 2005 - 07:08:54 CDT