Need a query to select data from a table

anilbhuvan · New User Joined: 18 Nov 2006 Posts: 4 Location: hyderabad

I have a table of 8 columns and the first 7 columns data are same in every Row but 8th column data is different.

colm1 colm2 ......colm7 colm8
aa aa................ aa X
aa aa................ aa Y
aa aa................ aa z
aa aa................ aa A
aa aa................ aa B
aa aa................ aa C
aa aa................ aa D
aa aa................ aa E

Now i need to retrieve the data like : "aa aa ........ aa X, Y,Z,A,B,C,D,E"
including the commas

Can anyone give me the Query for this

murmohk1 · Posted: Wed Mar 12, 2008 1:21 pm

Anil,

Copy the table content into flat file and use sort utility to get the result.

anilbhuvan · New User Joined: 18 Nov 2006 Posts: 4 Location: hyderabad

murmohk1,

I need a query to do that operation... i requirement is to have a query for that scenario

MCEVOY · New User Joined: 21 Nov 2005 Posts: 18

QMF is great for this sort of thing, using the ACROSS function.

stodolas · Posted: Wed Mar 12, 2008 5:29 pm

A simple query can not do what you are asking. SELECT statements combing multiple rows in multiple columns don't work like you want them to.