Hi Friends ,

I have a requirement to display all values of a particular column in a row(like column names) .

i.e

i j k-------------columns
-- -- --
1 'a' 'aa'
2 'b' 'bbb'
3 'c' 'ccc'

now i need a query that shows the below out put..i.e displaying all the values of the column j horizantaly (in a row)

'a' 'b' 'c'

Thanks ,
Sush

I looked at your other posts to see what type of server you were using but was surprised to see you are posting queries on Oracle, MySQL, Postgre SQL, SQL Server, MySQL and DB2! What do you use in real life? why are you posting questions on so many different server types? Would it be worth getting a bit more experience with SQL before moving so rapidly between server types? Do you realise you've missed out posting queries on the Sybase forum?

Mike

SELECT j FROM your table name

bzzzt, wrong -- this produces values vertically

your solution is horizontally challenged

sush, look up GROUP_CONCAT in da manual, it will likely do what you need

but Rudy that will only work on MySQL! what about all the other servers sush is working with such as Oracle, Postgre SQL, SQL Server and DB2 - is there no solution to all his problems?

no idea, mike, i was just answering the question that was asked in the forum that it was asked in

...money?

no solution to his problems...
try alcohol.....

as Rab C Nesbit will testify alcohol helps the world pass by

Ahhh yes, that does give the game away a little bit. I'd so much fun following all his other posts in all the other forums that I just assumed (wrongly) he'd posted under database design