Re: Return Single Row with Multiple Cols Instead of Multiple Row

Anil G wrote:

> Is it possible to return single row with multiple columns instead of
> multiple rows.
>
> Basically, query returns following hierarchy.
>
> product classification parent Classification
> ABC Motorcycle Motorcycle
> ABC On Road Motorcycle
> ABC Casual On Road
> ABC Model Casual
>
> Hierarchy is not fixed level,and values of classification change based
> on product.

And..? Is the above the result that you want, or how the actual data looks like? Or do you want all of that displayed as a single row.. and if so, why? Or do you want to pivot the data and make rows into columns and columns into rows?

You must try harder mate. Especially since I've only just started on my first cup of coffee and it takes some time for it to set the old mind in motion.

--
Billy